web

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

News and Announcements icon

Power Platform CommunityForums Power Automate Filter array 'is great...

Power Automate

Answered

Filter array 'is greater than or equal to' minus date is being ignored

(0) Share

Report

Report

Posted on by Amy-LJ

4

We have a flow built that includes a Filter Array with a Filter Query applied, as screenshot.

The final part of the query @ticks(addDays(utcNow(dd-MM-yyyy),-7))) includes -7 but this is being ignored and the email we receive includes data for postings from utcNow -46 days.

Can anyone advise what is causing this.

Attached here also is the Select 2 element of the flow

Thanks.

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Amy-LJ ,

In the new designer, you need to click on the fx logo and then enter the formula.

Please try this expression:

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

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Amy-LJ 4 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much, this has resolved the issue and the expected data is now presented in the email received.

Was this reply helpful? Yes No

Join the conversation