Unanswered

Power Automate to email upcoming due dates from Sharepoint List

(0) Share

Report

Posted on by John_PSH

Hello. I have a SharePoint List with a ContractEndDate date column. I used the "SharePoint Remind Me" flow (https://learn.microsoft.com/en-us/power-automate/create-sharepoint-reminder-flows) and it works well for notifying me on the day something comes due, i.e. 30 days before the ContractEndDate. What I would prefer is to have the email send me not just the item coming due in 30 days, but any that are due within the next thirty days. I'm sure it has to do with the Filter Query that is the default, but I just can't seem to figure out how to change it. Right now the default concat expression looks like this:

concat(concat('ContractEndDate',' ge ', '''',outputs('Today_+_x_days')),'''',' and ', concat('ContractEndDate',' lt ','''', outputs('x_Days_+_1'),''''))

I had thought it should be something like ContractEndDate GE today and LT Today + x_days. X being 30. But, everything I try fails.

Anyone have any thoughts? I'm new to PowerAutomate so I would like to pretty much stick with the Flow built by the "SharePoint Remind Me" flow.

Thanks...John

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (1)

Report
Since you are new to Power Automate I would recommend you store the date values in Compose actions. Use one to store today's date and one to store the date 30 days from now.

You need two expressions for the dates.

Today:
formatDateTime(utcNow(),'yyyy-MM-dd')

30 Days from Today:
addDays(utcNow(),30,'yyyy-MM-dd')

The Filter Query would look like this:
ContractEndDate ge '[today output here]' and ContractEndDate lt '[30 day output here]'
Insert the appropriate output between single quotes.

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

Was this reply helpful? Yes No
John_PSH 7 on at

Like (0)

Report

Thank you for the assist. I ended up using part of your suggestion. I used the Compose to create the two expressions, but I had trouble putting the Outputs into the Expression. They kept telling me they failed. I switched back to the concat which was in the original flow template and adjusted for the two new expressions I created. That seemed to work, but I got an error. Seems I misspelled "FormatDateTime" as "FormateDateTime" and that caused my expression to fail. I found that error and fixed it and all worked. It may have been what caused the Outputs in the Expression to fail, as well. Thank you so much for your assistance.

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (1)

Report

No worries. I do prefer using the Compose actions (personal preference) makes it easier to read and breaks up the overall expression in chunks.

If you are using the addDays() function, there isn't a need to add a formatDateTime() as you can define the date/time format right in the addDays() function.

To insert the Compose outputs into the Filter Query, you need to insert them between single quotes. The Compose action should appear in the Dynamic content list to select from. Once you select it, it should insert the dynamic content in between the single quotes.

Was this reply helpful? Yes No