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!
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.
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.
UPDATE: We’re excited to announce some significant updates to Flowr for Power Automate! As of October 2024, we’ve improved by updating action names and splitting Flowr’s central Power Automate connector into nine specialized connectors. These changes will make your workflow faster, smoother, and more efficient. The new action names are more precise and intuitive, saving you time, while the focused connectors enhance performance and flexibility. This update also helps future-proof the platform for even more powerful features. Check out our updated action names blog.
Managing Director