I'm a bit new with using MS Power Automate, and i'm currently working on creating a search and extract flow. the flow goes as the following:
1- Read and extract specific data from an email and place them into an array of strings
2- Open an Excel workbook (OneDrive) which contain multiple sheets
3- Lookup information of each index of the array to find a match in the workbook
- If there's a match, then extract the info of that whole row
- If no match, move on without extracting anything
4- Email the outcome which contains each index and the outcome of the search
i've tried Get Row function, but it works only if there's a match. if there's no match it gives me an error. Any support on this would be much appreciated.
Hi @ChristianAbata, thank you for the quick response. the email is structured as the below attachment
The email is a standardized template and all paragraphs are standarized, the only text that changes is the colored text and it's what i would like to extract where:
- Text in red is extracted and typed in the results email
- Text in green is what needs to be exctracted into an array to search for a match in the excel workbook
Also, keep in mind that the size of the text in green changes where an email could get 4 member names, and the next email could have 8 member names.
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!