Power Automate

Date filter for List rows

(0) Share

Report

Posted on by Narayan_s

How can i use date filter in power automate

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Suggested answer

Narayan_s 78 on at

Like (0)

Report
Copy link

Link copied!

Provide suggest how can i filter between dates.

Was this reply helpful? Yes No
Suggested answer

Riyaz_riz11 4,171 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi Narayan,

Please have a look:

Created ge '@{formatDateTime(utcNow(),'yyyy-MM-ddT00:00:00Z')}'

and

Created lt '@{formatDateTime(addDays(utcNow(),1),'yyyy-MM-ddT00:00:00Z')}'

This returns items created today.

Created ge '@{formatDateTime(addDays(utcNow(),-7),'yyyy-MM-ddTHH:mm:ssZ')}

This returns items created in the last 7 days.

Suppose your SharePoint column is DueDate and you want items for 01-Jan-2026:

DueDate eq '2026-01-01T00:00:00Z'

Filter Between Two Dates

DueDate ge '2026-01-01T00:00:00Z' and DueDate le '2026-01-31T23:59:59Z'

If I have answered your question, please mark it as the preferred solution ✅ . If you like my response, please give it a Thumbs Up 👍.
Regards,
Riyaz

Was this reply helpful? Yes No
Suggested answer

Riyaz_riz11 4,171 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Narayan,

Please have a look:

Created ge '@{formatDateTime(utcNow(),'yyyy-MM-ddT00:00:00Z')}'
and
Created lt '@{formatDateTime(addDays(utcNow(),1),'yyyy-MM-ddT00:00:00Z')}'
This returns items created today.

Created ge '@{formatDateTime(addDays(utcNow(),-7),'yyyy-MM-ddTHH:mm:ssZ')}
This returns items created in the last 7 days.

Suppose your SharePoint column is DueDate and you want items for 01-Jan-2026:

DueDate eq '2026-01-01T00:00:00Z'

Filter Between Two Dates
DueDate ge '2026-01-01T00:00:00Z'
and
DueDate le '2026-01-31T23:59:59Z'

If I have answered your question, please mark it as the preferred solution ✅ . If you like my response, please give it a Thumbs Up 👍.
Regards,
Riyaz

Was this reply helpful? Yes No
Haque 3,382 on at

Like (0)

Report
Copy link

Link copied!

Hi @Narayan_s,

Do you have any particular use case to share with?

Was this reply helpful? Yes No
Suggested answer

chiaraalina 2,190 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi

For Dataverse Filtering:

Between two dates:

createdon ge 2024-08-01T00:00:00Z and createdon le 2026-12-31T23:59:59Z

Filter last 7 days:

createdon ge @{addDays(utcNow(),-7)}

Between start date and today:

createdon ge 2026-01-01T00:00:00Z and createdon le @{utcNow()}

Use the logical name of your date column (e.g., createdon, modifiedon)

ISO8601 format: YYYY-MM-DDTHH:mm:ssZ

Values are case-sensitive

Operators: ge (≥), le (≤), gt (>), lt (<), eq (=)

How you find the Logical name in Dataverse:

When filtering Dataverse (or SharePoint) lists with more than 5,000 items, you have to turn on Pagination.

Set Top count to 5000 or your threshold (max 100,000).

Let me know if you need filtering in SharePoint or Excel.

Was this reply helpful? Yes No
Suggested answer

11manish 2,647 on at

Like (0)

Report
Copy link

Link copied!
In Power Automate, filtering between dates depends on where you're applying the filter:

Dataverse List Rows

SharePoint Get Items

SQL queries

Filter Array action

Trigger Conditions

Please share more detail about your requirement.

Was this reply helpful? Yes No
RobElliott 10,507 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Just to plug a minor gap in the previous answers, filter queries use the following:

eq = equal to

ne = not equal to

gt = greater than

ge = greater than or equal to

lt = less than

le = less than or equal to.

Rob
Los Gallardos

Was this reply helpful? Yes No