I have seen many examples of using substring but it is not working for me. I have the following text extracted from email message:
Name: Mike Brown
I want to extract bnoth name and email and then generate a JSON object, something like this:
"name": "Mike Brown",
How do achieve this without using third party connector?
I use the substring expression :
substring(body('Html_to_text'), add(lastIndexOf(body('Html_to_text'), 'Name: '), 15), 😎
but I only get the word 'Mike'.
My flow is:
Hi @Anonymous ,
Please share the full message in the email body so we could make a test on my side and provide you a proper solution.
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the News & Announcements to learn more.
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Check out our new Discover Your Career Path blog post series and get all the details.