How to send mail every 24 hours until a response is received

[r_voyager]

Hi All,

I have a SP list in which I have a column 'Status' , this column changes to "Submitted" once a request comes for admin to respond. 
if within 24 hours no response comes and this column doesn't changes to "Completed", then I want to send email every 24 hours until status changes to completed. 

I used power automate scheduled flow but no luck, Can't figure out the logic.

[kylzbaba · Accepted solution]

Scheduled flow, get items where status = submitted and created date is greater than or equals to adddays(utcNow(), -1). This will fetch all the records with status submitted over 24hours ago. Then apply to each loop to send emails for the respective records.

If this helps, please accept as solution.

[ryleybauer · Accepted solution]

Hi @r_voyager , 

I'd recommend creating an automated flow for created/modified. Then you can check if the status is "Submitted" and run a DO UNTIL loop with a 24 hour delay.

Check this out, let me know if there are any questions and please accept as solution if this worked for you!