How to extract string between two Characters/tags

| Muhammad Uzair

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.


M
Chief Architect, Founder, and CEO - a Microsoft recognized Power Platform solution architect.

About The Blog

Stay updated with what is happening in the Microsoft Business Applications world and initiatives Imperium is taking to ease digital transformation for customers.


More About Us

We provide guidance and strategic oversight to C-Suite and IT Directors for on-going implementations. Feel free to give us a call.

1 331 250 27 17
Send A Message

Ready to Start?

Get a personalized consultation for your project.

Book a Meeting