How to extract string between two Characters/tags

This blog will explain the procedure one has to go through to extract string between two Characters/tags.

As we want to read Type tag from this is inside the entities tag. Read

<Type>Vendor</Type>

Find the first character position which would be like

add(int(indexOf(outputs('Compose_-_entity_list_xml'), '<Type>')), 0)

Find the last character position which would be like

add(int(indexOf(outputs('Compose_-_entity_list_xml'), '</Type>')), 7)

Find the total character in between first and last

sub(outputs('Compose_-_LastPosition_5'), outputs('Compose_-_Position_5'))

Compose the complete string “<Type>Vendor</Type>”

substring(outputs('Compose_-_entity_list_xml'), outputs('Compose_-_Position_5'), outputs('Compose_-_LastIndex_5'))

Join us next time, as we continue our journey of learning canvas apps.Click here to learn more about Imperium's Power Apps Services. We hope this information was useful, and we look forward to sharing more insights into the Power Platform world.

---