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 (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 (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 (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