Issue with odata filter - Get Items

(0) Share

Report

Posted on by Community Power Pla...

Hello,

I have created a flow that fetches record from SharePoint list and sends a weekly report.

I need to fetch all the records of last 7 days but it is fetching only record of 1 day.

Created - date and time field (Ex : 2022-03-10T12:58:51Z ).

Can someone help me with the condition @ filter query

Thank you.

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (1)

Report
You can try the following expression and filter query:

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

For example, in the following filter query I am searching for items that were created on or after 2022-03-10T00:00:00 which is 7 days ago from 2022-03-17:

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi ekarim,
Thanks for the response. I did try above condition but It is fetching only record that were created on 10-03-2023.

Was this reply helpful? Yes No
Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (0)

Report

Please share the filter query and the expressions for the data calculation.

Ellis

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Was this reply helpful? Yes No
Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (0)

Report
You can add the following compose action after Get Items to count how many items are returned:

length(outputs('Get_items')?['body/value'])

Please show the runtime output of the compose action once you have run the flow.

And please also check the SharePoint list to confirm how many item there are with a created date greater or equal to: addDays(utcNow('yyyy-MM-dd'), -7)

Ellis

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

There are 690 records in the SharePoint list which were created between 10/03/23 to 17/03/23. But it is fetching only 100 records.

I did increase the default limit for get items and the flow is working as expected. Thanks for the help @ekarim2020

Was this reply helpful? Yes No