Unanswered

Making a flow that itterates through a sharepoitn list, and sends an email for each date in that collum that is approaching

(0) Share

Report

Posted on by aaron_h

Hello,

I am trying to make a flow that given a Sharepoint list with multiple dates per item, will send an email to the person the item references when 1 or more of those dates is approaching (by 30 days), and details which one it is.

I am very new to power automate, and Microsoft 365 in general, so really have no idae where to start. My original idea was to attempt to use the 'get an expiry reminder' template and then modify that, but that just looks far to confusing to work with, and only handles 1 collum, and when selecting it, I don't even know what collum it has selected to remind for.

Any help figuring this out would be greatly appreciated.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

@aaron_h You can create Scheduled cloud flow, schedule it to run daily. Then add Get Items action to get data from SharePoint list, here you have to configure Filter Query in get items action to get only those items whose date is approaching in next 30 days, so can you please share the structure of your list so that i can further advise you on how to configure the filter query.

Was this reply helpful? Yes No
aaron_h 8 on at

Like (0)

Report

by strucutre, do you mean teh content of the list, or just how it is set out?

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

@aaron_h i mean how the list is set out, the columns of list and their data type.

Was this reply helpful? Yes No