Unanswered

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

(0) Share

Report

Posted on by r_voyager

130

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (2)

Verified answer

kylzbaba 182 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

ryleybauer 327 on at

Like (1)

Report

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!

Was this reply helpful? Yes No
ambi95 34 on at

Like (0)

Report

Hi @ryleybauer can you explain the reason why we have to do the last step "get item" please?

Was this reply helpful? Yes No
kylzbaba 182 on at

Like (1)

Report

Because if you use the values from the trigger body (when an item is created or modified), it will still be the original values in the scope. The get item runs to fetch the updated values if an update has been made.

Was this reply helpful? Yes No
ryleybauer 327 on at

Like (1)

Report

@kylzbaba is right, it's just because we want to double-check the values after the delay before we rerun it in case an update has been made.

Was this reply helpful? Yes No
ambi95 34 on at

Like (0)

Report

thank you @ryleybauer and @kylzbaba 🙂

Was this reply helpful? Yes No
ambi95 34 on at

Like (0)

Report

Hi @ryleybauer I tried this but it keeps sending me emails even when the condition is not being met

Was this reply helpful? Yes No
ryleybauer 327 on at

Like (0)

Report

Sorry for the late reply, but if you are still getting emails, I would assume something isn't right with your condition. Reminder that I'm using the last step of the loop as the value. You could additionally set a variable and/or use a compose step to see the value in each loop for troubleshooting.

Was this reply helpful? Yes No