05-19-2020 23:27 PM - last edited 05-20-2020 08:26 AM
Title: Data extraction and parsing from an email
Description: This Flow triggers on an email received to check its body on a dynamic number of keys to find its corresponding value. The trick is in an Apply to each loop based on an array you can manage from within the flow. The flow will find the keys and values you want to extract and parse.
Detailed Instructions: It’s as easy as importing the zipped flow attached, add your connection for Outlook Office 365 and it will trigger on your own inbox emails. I recommend additional filters (like a specific unique phrase in the subject or only a specific mailbox folder) so the flow will only trigger on emails that it should trigger on. Keep in mind that the flow expects a specific key to find and you can change the key in the array step of the flow. You can even change the key-value separator as explained in the video.
Questions: Please feel free to ask anything right here as a reply in this post.
watch?v=e_8hQibvbYQ
Hi @Django ,
I hope you well.
My flows work perfectly now. I am use some condition and modified it based on your suggestion.
Thanks for your guidance, idea and support!
I am appreciated it 😉
Keep the good work brother.
Hi @Django
I really liked the video and over all explanation. However, I have a case where my values do not have a key.
I just have a bunch of values separated by ',,'. Is there a way to extract these values into multiple variables (one value each variable) and push those variables to some spreadsheet cell.
I am trying to parse an email and then extract some values into spreadsheet.
After trigger, I am using combination of functions to split and then join my values of interest with ',,' as delimiter.
My data looks something like this - value1,,value2,,value3,,....
Here are the steps I have performed so far. I think I can apply apply to each somehow not sure of the exact process.
Thank you!
Hi , very nice to be helpful!
In your case if you have a consistent string with always the same order, always the same separator ==> like value1,,value2,,value3,value4,,value5
0 at the end would be the first value of your string = value1
1 at the end would be the second value of your string = value2
and so on... 👍
Did you see my response @Anonymous ==> the Power Platform Community Forum has some HTML buggy clean up / post flooding detection mechanisme which does not allow me to submit a post with code and functions very easily / right away...
Be sure to verify if the single quote ' is copying correctly from my examples. You may need to type these yourself just to be sure 🤓
Just saw. I think there was some issue before. Thanks a lot, @Django! I'll use it and let you know if this works.
Hi Django,
Thank you for your video. After importing the flow, I see two issues which I think are related
I am unable to double click on the Parameters, such as UserID, Email, inside the "Send an email". I also don't see them listed in the dynamic content. I already ran a test email with the same input data as shown in the video.
Hi Django,
This is such a helpful post. Thank you for sharing it. I've tried to run your test and the KeyToFind isn't finding what it should be right now. My data is split over several lines, could that be the cause of the issue? How would I adjust that? I'm also looking for phrases with spaces i.e. "Payment method". Would that cause an issue?
Thanks,
Liz
I get the following error when I try to import FlowTest-EmailgetData_20200520061714.zip into PowerAutomate (Solutions -> Import):
The solution file is invalid. The compressed file must contain the following files at its root: solution.xml, customizations.xml, and [Content_Types].xml. Customization files exported from previous versions of Microsoft Dynamics 365 are not supported.
What am I doing wrong