Power Platform Community Forum Thread Details

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

Categories:

Building flows