PowerAutomate Flow - Building Flow based on Email Attachment

[Mudd_Duck]

Looking for some help trying to sort out a flow to do the following

When a new email arrives via shared do the following

1) Save the email as PDF on provided sharepoint site

2) Save/Create a file based on attached file to sharepoint site

3) Open attachment and review pre-determined column value to see if it contains exact text

3.1) If file has exact text in any cell in Column 1, then send email

3.2) Otherwise do nothing. 

I've been able to work out step 2 fairly easily and I know Step 3.1 and 3.2 use a condition then send an email, but Im struggling with step 3. Using a flow to systematically "open" a file and then based on pre-defined values in column1, take action. 

Case Example 

Individual returns, via email, a completed spreadsheet to a shared mailbox. Their completed spreadsheet gets sorted by their set responses in Column A and based on their responses the spreadsheet gets either saved to folder A or folder B and if folder A, then send an email notification. 

 

[Koen5]

Dear Mudd,

Your step 3 "Open attachment and review pre-determined column value to see if it contains exact text" is certainly possible, but the hints below should help you further:

• Save the attachment to a OneDrive/Sharepoint folder ... and WAIT before you try and access this file again. It seems that PowerAutomate needs some time to use files which it has created in the same flow immediately. So after saving the file, build in a delay of a couple of minutes.
• You cannot read Excel files if there is no defined table. If there is no named table in the file already, you can create one with the 'Create Table' action in the excel actions. When you have named the table, you can read the contents of the cells with the 'List rows in table' action.
• Sometimes the attachment on an outlook email show as 'corrupt', to prevent this. I had it so now and then. Use the instructions as per link to prevent it: https://tomriha.com/how-to-avoid-corrupt-email-attachment-in-power-automate/

Hope the tips help,

Happy flowing,

Koen