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.
my table in email is fixed as above table, so i set a loop to extract the text cell by cell.
i need to know how many rows
how many cells(column)
extract all the cells in one loop, then loop the next row