Filter array question

(0) Share

Report

Posted on by RodneyCheung

Hi all,

Sorry that I created the flow on filter array, like below, the expect result should be 2-Aug-2023 only,

@And(greater(item()?['Target Date'], addDays(utcNow(),-7, 'yyyy-MM-dd')),equals(item()?['Completion Date'], ''))

But after ran, the result is like below,

2023-08-09 14_46_43-Window.png

Raw data:

2023-08-09 14_48_17-Window.png

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-mingkz-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @RodneyCheung,
Could you please tell me more about your requirements and scenarios?
The expression in your filter query is get the Target Date greater than 8.2 and Completion Date is blank. (Such as 8.10/8.11....)
If you just want to get the Target Date equal to 8.2.
You should use the following formula:
@And(equals(item()?['Target Date'], addDays(utcNow(),-7, 'yyyy-MM-dd')),equals(item()?['Completion Date'], ''))

Best Regards,
Kyrie

Was this reply helpful? Yes No
RodneyCheung on at

Like (0)

Report
Copy link

Link copied!

Dear Kyrie,

Thank you so much for your reply,
I want to have an email reminder if the "completion date" is empty, and check "target date" is today - 7.
This flow will perform every day, remind us of which record is not yet completed.
For example: today is "9-Aug-2023", then the result should be "2-Aug-2023" of record.
But now, 10-Aug to 21-Aug of records also display on email.

Excel raw data:

Email reminder message:

Thank you so much.

Best regards,
Rodney Cheung

Was this reply helpful? Yes No
Verified answer

v-mingkz-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
@RodneyCheung,
Please try:
@And(equals(item()?['Target Date'],addDays(utcNow(),-7,'yyyy-MM-dd')),equals(item()?['Completion Date'],''))

Was this reply helpful? Yes No
RodneyCheung on at

Like (0)

Report
Copy link

Link copied!

Dear Kyrie,

Thank you so much for your reply and help.

Best Regards,
Rodney

Was this reply helpful? Yes No