Unanswered

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

(0) Share

Report

Posted on by Amy-LJ

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:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-yetonggu-msft on at

Like (0)

Report
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

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