Unanswered

Recurrence Flow (Scheduled Flow) _ Date and Time formula issues

(0) Share

Report

Posted on by AB-17090632-0

Hi all,

I have build a Share point list and one of the columns (set as Date and Time, Date Only) needs to send follow up emails. So, based on the date introduced in this column, I need to find the exact formula that can help me set the follow up email at the date introduced in the column (editable for the users, so, can be any date...) + 60 days.

I have build a Recurrence Flow (Scheduled Flow), and added actions: Get Items, Filter Array and added "Apply to each" and "Send Email".

Can you please help me with the right formulas that should be introduced in the "Filter Array"? I suspect there is an issue.

Thank you,

Adriana Badanoiu

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Expiscornovus 33,871 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @AB-17090632-0,

You can use the adddays function for this.

Compare your Date column with the below expression

addDays(utcNow(), -60, 'yyyy-MM-dd')

Below is an example, if that helps?

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, LinkedIn, Bluesky profile or Youtube Channel

1 people found this reply helpful.

Was this reply helpful? Yes No
Building with Why 351 Moderator on at

Like (0)

Report
Copy link

Link copied!

To expound on the below response.

You don't need a Filter. You can use the Get items step to filter by the SharePoint column. This will do 2 things, 1) it will reduce the number of records you pull from SharePoint and 2) reduce the number of steps, making it marginally faster.

Second is that the filter needs to be in the 'yyyy-MM-dd' format. Power Automate filters based on the year being first, so if you use the month or day first you will get odd results.

Third, make sure you have turned Pagination on, SharePoint only grabs the first 100 records that meet the filter requirements without Pagination, which you will likely quickly exceed if you have not already exceeded it.

Mark this answer as liked and answered if it helps.

If you need additional assistance check out my website www.nextsteplabs.tech. I have some of my YouTube videos there.

1 people found this reply helpful.

Was this reply helpful? Yes No