Unanswered

Flow to pull last 7 days in Sharepoint list not working.

(0) Share

Report

Posted on by Amy1349

Hi All,

I built a recurring flow that will send me an email every Monday with the items populated in a SharePoint list. The flow works except that I only need it to pull the last 7 days of items. I tried doing a "Filter Query" but am not able to get the flow to work once that has been added. I am not sure how to get this to work at this point. Any help would be greatly appreciated.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

fchopo 8,003 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @Amy1349

You're on the right path! In the filter expression you need to add the column name and the OData operation (greater than (gt), greater or equal than (ge)). So you would write something like this in the filter query expression:

modified ge addDays(utcNow(),-7)

You should use ISO 8601 format for dates and times (yyyy-mm-ddThh:mm:ssZ) and the expression addDays returns dates in that format.

Hope that helps!

Ferran

Was this reply helpful? Yes No
Amy1349 28 on at

Like (0)

Report
Copy link

Link copied!

Hi,
I probably entered this wrong but I am still getting error messages. Sorry I am pretty new to this and teaching myself as I go.

Was this reply helpful? Yes No