Flow for a reminder email

(0) Share

Report

Posted on by Aleisha

Hi,

I am still relatively new to power automate so would appreciate some guidance.

How can I generate a flow to run every day for any items on a SharePoint list that has both the column with the option "incomplete" and has not been modified in 5 days? I would like an email each day with the list of items that meet the above criteria.

Thanks,
Aleisha

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

mrcwojcik 49 on at

Like (0)

Report

Flow for a reminder email

Hello,
you should start with this trigger:

then use action Get items (Sharepoint connector):

clue is to use Filter query to get records you need to. For example to get items with attribute incomplete you shoudl have something like that:

YourColumnName eq 'Incomplete' and Modified le addDays(utcNow(), -5)

And then you can use Email in Apply to Each control.

Was this reply helpful? Yes No
Aleisha 30 on at

Like (0)

Report

Flow for a reminder email

Hi there,

Thank you so much for replying. Can you please explain in more details about the filter query?

Thanks,

Aleisha

Was this reply helpful? Yes No
mrcwojcik 49 on at

Like (0)

Report

Flow for a reminder email

Action Get Items will fetch all records from your list. But you can filter this list and fetch only those data you need to. Look on this:

How to Use Power Automate Filter Query [Guide With Examples] - Citizen Development Academy

Was this reply helpful? Yes No
mrcwojcik 49 on at

Like (0)

Report

Flow for a reminder email

Hey Aleisha, did my answer help?

Was this reply helpful? Yes No