News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Sent Email if [Created...

Power Automate - Building Flows

Unanswered

Sent Email if [Created date time] or [Date Field] is greater than [x] days from sharepoint list

(0) Share

Report

Report

Posted on by Community Power Pla...

Hello,

I'd like to know how Sent Email if [Created date time] or [Date Field] is greater than [x] days from sharepoint list.

How currently I use my flow:

2020-10-01 09_02_05-Window.png

However I get error and I guess I don't have much experience with power automate.

2020-10-01 09_05_17-Window.png

And I'm using formula wrong.

Thank you.

Categories:

Business Process Flows

All responses Img

All responses (1)

Answers Img

Answers (0)

sudharsan1985 1,325 on at

Like (0)

Report
Re: Sent Email if [Created date time] or [Date Field] is greater than [x] days from sharepoint list

Hi @Anonymous

You do not need to use Apply to each to check the condition. The same will affect the performance since you are retrieving all the items and then doing the filter instead, and you can use the Filter Query property in the Get Items action to return only the results that satisfy your condition.

Use the below code to calculate the date after 30 days.

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

Use the query below in the Filter Query.

Created gt '<30 days code mentioned above>' OR [Date Field Internal Name] gt '<30 days code mentioned above>'

Try the above, and it should work.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 497 Super User 2025 Season 1

#2

David_MA 436 Super User 2025 Season 1

#3

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans