Unanswered

Filtering Data with OData Date in SharePoint

(0) Share

Report

Posted on by lwarix

Hi -

I am trying to filter out items that have been added within the last 6 days. We have a column named Date_x0020_Added it should be returning approx 20 items. There are 850 records in the list.

I've tried every combination I can think of. Any help would be appreciated.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Sort by

abm abm 32,985 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Try using the below expression

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

https://www.youtube.com/watch?v=L4vpYLfwTRk

Also by default Get Items only return 100 items. Go to settings and increase the threshold.

Thanks

Was this reply helpful? Yes No
sudharsan1985 1,325 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @lwarix

Try to use the expression below

<Source: Date column> <Condition: greater than or equal to> <Value: addDays(utcNow(), -7, 'yyyy-MM-dd'))>

Also please refer to the below link which has the same requirement.

https://powerusers.microsoft.com/t5/Building-Flows/Help-with-pulling-a-certain-item-for-the-past-7-days/m-p/734438#M100580

Was this reply helpful? Yes No
sudharsan1985 1,325 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @lwarix

Try to use the expression below

<Source: Date column> <Condition: greater than or equal to> <Value: addDays(utcNow(), -7, 'yyyy-MM-dd'))>

Also please refer to the below link which has the same requirement.

https://powerusers.microsoft.com/t5/Building-Flows/Help-with-pulling-a-certain-item-for-the-past-7-days/m-p/734438#M100580

Was this reply helpful? Yes No