cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tom_Kingsly
Helper I
Helper I

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

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

7 REPLIES 7
Mira_Ghaly
Dual Super User
Dual Super User

@Tom_Kingsly 

Can you share screen shot of your flow please?

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

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 !

 

Flow 1.PNG

d896535e-e0d0-4b86-b9be-17100cb00bcb.png

 

@Tom_Kingsly 

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

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here
Tom_Kingsly
Helper I
Helper I

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

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

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here
Tom_Kingsly
Helper I
Helper I

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

@Tom_Kingsly 

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

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (4,161)