Filter Query in Get Items (SharePoint) using dates

(0) Share

Report

Posted on by Community Power Pla...

I have been searching and can't seem to ask the right search question to get what I need.

I have a flow that I want scanning through a SharePoint list and checking each row's date. If the date is between today and the last 6 or 7 days, I want it to grab that row for use. I am creating a report of things that happened from last Thursday until today. (The report will always be run on a Thursday)

So, what's the syntax for: "if <date column in list> is greater than <7 days ago>, use this row"?

I may also want to give the user the ability to set the dates they want to search between, So, what might the syntax be for:

"if <date column in list> is between <var1> and <var2>, use this row"?

Thank you for your support

Frank Puthuff