web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Getting the filtered r...
Power Automate
Unanswered

Getting the filtered records from the SP List to power automate flow(for the first time)

(0) ShareShare
ReportReport
Posted on by

I have SharePoint list of 1000 items and I want to send an email through power automate, based on condition.
When the system date is 10/10/2022, The power automate flow should pick the records dated 10/17/2022 - 10/22/2022 and send email to Managers
When I tried with get list Item( get items action in flow), I am getting all the 1000 Items. Later I apply the condition to filter the 10/17 - 10/23 records only.
But Is there any option to get just the 10/17 - 10/23 records only(first time)?

Categories:
I have the same question (0)
  • srduval Profile Picture
    1,760 Moderator on at

    You'll have to google it if you have problems, but follow the details about passing the odata filters for date values here:

    Solved: ODATA to filter Get Items Sharepoint: DateTime val... - Power Platform Community (microsoft.com)

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 283

#2
David_MA Profile Picture

David_MA 256 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard