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

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@Tom_Kingsly

Can you share screen shot of your flow please?

Was this reply helpful? Yes No
Tom_Kingsly 34 on at

Like (0)

Report

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 !

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@Tom_Kingsly

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

Was this reply helpful? Yes No
Tom_Kingsly 34 on at

Like (0)

Report

@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.

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (1)

Report

@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!

Was this reply helpful? Yes No
Tom_Kingsly 34 on at

Like (0)

Report

@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 ?

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@Tom_Kingsly

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

Was this reply helpful? Yes No