I need your help! I've been stuck on this project for a long time!

[Tom_Kingsly]

Hi All,

I am creating a flow that works when a new email arrives in our shared mailbox. I maintain a list of keywords in an online Excel file. Whenever a new email arrives in the inbox, I want the flow to search for the keyword in the online excel files. An email should be sent if the word matches the email and the excel. The flow I created reads the first line in the online excel but not the other lines. Please assist me in how to make this work.

Thanks in advance for your help!

Tom Kingsley

[Mira_Ghaly]

@Tom_Kingsly 

Can you share screen shot of your flow please?

[Tom_Kingsly]

Hi @Mira_Ghaly

Thanks for your reply 

Here is my Flow, I added a condition to match the body of the message with the keyword. The flow works, but it searches only the first line on excel. 

Thanks for your help !

 

[Mira_Ghaly]

@Tom_Kingsly 

So does the list rows return only 1 record can you check flow run run history?

[Tom_Kingsly]

@Mira_Ghaly 

Yes, it returns results only for the first row in excel. It is not searching other keywords on the excel sheet. I want the flow to run and check all the results. 

[Mira_Ghaly]

@Tom_Kingsly 

I believe issue will be in the excel table itself not all rows are within the table range so can you make sure you reselect all rows in your excel and re-format as a table and retry!

[Tom_Kingsly]

@Mira_Ghaly 

I did check the table query everything looks correct. But the flow returns the same result it's not reading the next row in the excel sheet. Do we have any other work around ?

[Mira_Ghaly]

@Tom_Kingsly 

Is it possible to share how your flow run history looks like?