Scheduled power automate flow to send email for deadline approaching

(0) Share

Report

Posted on by George234

132

I am quite new to Power Automate so any help is appreciated.

I have a Team which I have added a Microsoft List in one of the tabs for project management between employees. The Manager creates a project and assigns the project to another person for proceeding the tasks with a deadline for the project.

In sharepoint, the deadline column is a 'date and time field' and the assigned column is a 'person or group' field.

I want to do a scheduled power automate flow to run daily to check the deadline date column and send a reminder email to the person who is assigned for that project that the deadline is approaching (say 5 days before) .

Can someone please advise the steps on how to achieve this?

Categories:

Using flows

I have the same question (0)

All responses (14)

Answers (1)

eric-cheng 5,171 on at

Like (0)

Report

Hi @laz8592 ,

Try the below.

The formula in the filter will get all files where ExpirationDate is 5 days away.

@formatDateTime(addDays(utcNow(),-5),'yyyy-MM-dd')

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No
George234 132 on at

Like (0)

Report

Hi Eric

I applied all the settings as per your workflow, and did a test and everything was checked. BUT , when the flow ran on scheduled no emails went to the assigned email.

I have a feeling that maybe something wrong with the library name as I have to enter a custom value as it doesn't find it when getting item properties (it only sees documents), it only sees the site (see below). It is a list not a library.

Was this reply helpful? Yes No
eric-cheng 5,171 on at

Like (0)

Report

Hi @laz8592 ,

Are you looking for list items or documents in a library?

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No
George234 132 on at

Like (0)

Report

List items.

Was this reply helpful? Yes No
eric-cheng 5,171 on at

Like (0)

Report

Hi @laz8592 ,

You can use Get Items and the same filter

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No
George234 132 on at

Like (0)

Report

Hi Eric

Even with the 'get items' filter, no emails arrive in the mailboxes. The assigned emails is a column whereby the emails are added in.
No emails are sent to these even when adjusting the deadline dates to be less than 5 days. Is the timezone have to be utc time like in the filter? I have european time on my site , maybe that's why ? The test of the flow is all ticked too.

Was this reply helpful? Yes No
George234 132 on at

Like (0)

Report

Any News?

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

Hi @laz8592

I appreciate you reaching out to me, from what I can see from above it would appear that despite using get items and the filter expression date eq formatDateTime(addDays(utcNow(),-5),'yyyy-MM-dd'), your emails are not being sent.

Presumably you have an apply to each on the value from the get items action which sends the email but I understand no email is sent.

To help me help you, I would need a screenshot of your flow, but also, I think it would be worth you exploring the history of the get items, does it return 0 items? If so the filter is not working. Can you check if the date includes a time on the List?

This is what I would expect your solution to look like:

This is how you check the history output of the get items:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉

Was this reply helpful? Yes No
George234 132 on at

Like (0)

Report

Thanks Damien,

The deadline column does not include time only date.

Attached my get items history and the output of the download.

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (1)

Report

Hi @laz8592

So you can see from the history at the end of the array that the value is an empty array []. Therefore there are no deadline dates equal to 2021-09-16. Can you check your list for list items with that date and if there is definitely one in there, create a new manually triggered flow, with the get items (no filter) and check the history output. You should be able to check for the deadline date in the history and hopefully debug what is going on?!

Columns have an internal name but if it is wrong, I wouldn't expect your get items to run without an error. So, try above, and hopefully we'll be able to solve your problem.

Damien

Was this reply helpful? Yes No