web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Power Automate Help wi...

Power Automate

Unanswered

Power Automate Help with Filter Query

(0) Share

Report

Report

Posted on by ehen

1

I fairly new to powerautomate and I need some help.
I have flow that is filtering a sharepoint list to send the results as a csv file.

On my SP list, I have name, location, dateadded columns.

Every Friday at 5pm, I want to pull all added items from location TX that were added within a full week.

I can't seem to get it to work, I have looked for examples and try them but can't get them to work.
Location eq 'TX' and DateAdded ge '@{formatDateTime(sub(utcNow(), 7, 'Day'), 'yyyy-MM-dd')}'

Any suggestions, thanks in advance.

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

David_MA 13,877 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Looks fine, but you will need to use this expression for the date filter:

formatDateTime(addDays(utcNow(),-7),'yyyy-MM-dd')

Was this reply helpful? Yes No

Join the conversation