
Announcements
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.
Looks fine, but you will need to use this expression for the date filter:
formatDateTime(addDays(utcNow(),-7),'yyyy-MM-dd')