Extract text between values with Power Automate

September 21st 2023
Back to all blogs

Post #4 of our Build Flows Faster series covers our new Utility actions for Power Automate. We will publish many more posts and accompanying videos over the coming weeks, but today’s lesson is about extracting text between values with Power Automate.

Our utility actions are targeted at helping you build flows more quickly with less complexity, and they brilliantly only use 0.05 actions from your Encodian Flowr and Vertr subscription allowance. For example, under a standard plan that permits 500 actions per month (uses), you could use the utility actions 10,000 times!

Introducing the ‘Extract Text between Values’ Utility Action

The ‘Extract Text between Values‘ utility action enables you to extract a value from a string (text) by specifying a start value and an end value.

Video Guide: Extract Text between Values in Power Automate

Instructions: Extract Text between Values in Power Automate

Consider the following flow: A web form submits a plain text email with contained details to a mailbox, and you need to extract information from the email before adding it to a SharePoint list for tracking purposes.

1. Add and configure the ‘When a new email arrives (V3)‘ trigger action

Below is an example of the email that will be received in the mailbox. I would like to extract the highlighted value:

2. Add the Encodian ‘Utility – Extract Text between Values‘ action

2.a. Text: Select the ‘Body‘ property provided by the ‘When a new email arrives (V3)‘ trigger action

2.b. Start Value: For this scenario, I will enter ‘How did you hear about us:

2.c. End Value: For this scenario, I will enter ‘Query:

3. Add the SharePoint ‘Create item‘ action

3.a. Site Address: Enter the target site’s URL

3.b. List Name: Select the target list

3.c. Pass the ‘Result‘ property provided by the Encodian ‘Utility – Extract Text between Values‘ action to the target SharePoint column

Upon executing the flow, the desired value should have been extracted and added to the SharePoint item:

If you require further advice or support regarding Encodian utility actions, please email our support team at support@encodian.com where the team would be delighted to help.

Author
Jay Goodison

Managing Director

Back to all blogs

You might also be interested in...