Answered

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

All responses (8)

Answers (2)

Sort by

Verified answer

kylzbaba 182 on at

Like
a
(0)

Report
Copy link

Link copied!

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.
Verified answer

ryleybauer 327 on at

Like
a
(1)

Report
Copy link

Link copied!

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!
ambi95 34 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Like
a
(1)

Report
Copy link

Link copied!

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.
ryleybauer 327 on at

Like
a
(1)

Report
Copy link

Link copied!

@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.
ambi95 34 on at

Like
a
(0)

Report
Copy link

Link copied!

thank you @ryleybauer and @kylzbaba 🙂
ambi95 34 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Like
a
(0)

Report
Copy link

Link copied!

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.