web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id : +VROE1nD5BREwWnHeeYeYi
Power Platform Community / Forums / 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

Like (0) ShareShare
ReportReport
Posted on 1 Oct 2020 06:07:19 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
I have the same question (0)
  • sudharsan1985 Profile Picture
    sudharsan1985 1,325 on 01 Oct 2020 at 07:21:37
    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.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

MS.Ragavendar – Community Spotlight

We are honored to recognize Ragavendar Swaminatha Subramanian as our September…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 954 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 650 Moderator

#3
trice602 Profile Picture

trice602 327 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans