web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Sending reminder based...

Power Automate

Unanswered

Sending reminder based on due date and status column

(0) Share

Report

Report

Posted on by RF_Souw

Hello,

I am quite new on using PowerAutomate.

I have a share point list which consists of:

a. request name

b. request date

c. request submission date

d. request status : new request, response submitted.

I am trying to build a flow to send a reminder with the following logic

> send a reminder a day before the request submission date only for the request name with request status is "new request"

Appreciate for any supports. 🙂

Categories:

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!
@RF_Souw

You need a scheduled flow that runs daily and use the getpast time to get 1 day earlier and then GetItems with Filter Expression as below:

FormatDateTime Expression:

formatDateTime(body('Get_past_time'),'yyyy-dd-MM')

Was this reply helpful? Yes No
RF_Souw on at

Like (0)

Report
Copy link

Link copied!

Hi Mira,

thank you for the response.

I was doing the same but when I tried adding Control Condition >> only sending a reminder if the request type is equal to New Request, the flow failed or not sending anything.

Was this reply helpful? Yes No
RF_Souw on at

Like (0)

Report
Copy link

Link copied!

can anyone have other suggestions? or help review my flow?

Was this reply helpful? Yes No

Join the conversation