Unanswered

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

(0) Share

Report

Posted on by 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

All responses (7)

Answers (0)

Mira Ghaly 11,409 Super User 2025 Season 1 on at

Like (0)

Report

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

@Tom_Kingsly

Is it possible to share how your flow run history looks like?
Tom_Kingsly 34 on at

Like (0)

Report

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

@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 11,409 Super User 2025 Season 1 on at

Like (1)

Report

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

@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 34 on at

Like (0)

Report

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

@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 11,409 Super User 2025 Season 1 on at

Like (0)

Report

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

@Tom_Kingsly

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

Like (0)

Report

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

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 11,409 Super User 2025 Season 1 on at

Like (0)

Report

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

@Tom_Kingsly

Can you share screen shot of your flow please?