This is because in indexing values we count the first value as index 0 Search text – This is the text we want to find the position of
Text – The text we want to use, in this case we use the dynamic content of our Compose with the email This action has Two(2) parameters to fill in: The Power Automate team has put together some actions that make Text Functions more easy.Īt this time there is Two(2) Text Function action we can utilize.įirst we will add the ‘ Find text position‘ action. In this example, we want to remove the At sign and everything after. In my Flow I will use a Compose action to store an email address, this can be any data source or action that fits your needs.
However we wont be using the expression Substring, we will be using a Action called Substring, this action can be found in the ‘ Text Functions‘ connector. We will be using Substring to achieve this. I will be showing how to grab an email address and transforming it to Josh Cook The Scenarioįor this demo, we will be formatting an email address and removing everything after the ‘ symbol, to form a first name and last name.
Luckily the product team makes things easier each day. Expressions can be confusing when starting out in Power Automate.
0 kommentar(er)
