cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JoeB_
New Member

Timed Event

Hi,

I'm building a flow which will look at rows in an excel table once a day

Column A - ID

Column B - Time
Column C - Status

 

I am trying to get the flow to look at any rows with a certain status "Waiting" for example, and if 24 hours have passed then it will send an email along the lines of:

"ID 123 has not received an update in over 24 hours, please provide an update"

 

How would this be achieved? And if there are multiple lines with "Waiting" status how can I make it repeat for each?

 

Appreciate any help

1 ACCEPTED SOLUTION

Accepted Solutions
v-alzhan-msft
Community Support
Community Support

Hi @JoeB_ ,

 

You could refer to screenshot below to create the flow:

1.png

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
JoeB_
New Member

I have worked out how to do the action but I cannot figure out the way to get it to run through the table and check the Status and time, any help here is amazing

v-alzhan-msft
Community Support
Community Support

Hi @JoeB_ ,

 

You could refer to screenshot below to create the flow:

1.png

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,431)