Microsoft Flow Filter Query

Richard Smith
Richard Smith used Ask the Experts™
on
Hi,

I am trying to trigger an action in Flow that happens every 20 days, the date comes from a SharePoint list, the column is ‘requested’ its in the format MM-dd-yyyy HH:MM:SS

I have added this filter in Flow but it is not working, is this formatted correctly?
gt 'addDays(utcnow(),-20,'yyyy-MM-dd')'

Open in new window

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Analyst Assistant
Commented:
Richard

Try using this,

utcNow('MM-dd-yyyy HH:MM:SS')

to match the formatting in the Sharepoint column.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial