Unanswered

How to make a Date as a condition in the Filter Array action

(0) Share

Report

Posted on by Del-Dev

160

I have 2 data in my excel sheet, [Alert Type] and [Date]. I am looking into how to make these 2 data into a condition in my "Filter Array" action in Power Automate. Below is the screenshot of my data from an excel sheet:

The condition for [Alert Type] and [Date] for the "Filter Array" action I'm looking into is if ([Alert Type] is greater than Red4) AND ([Date] is equal to OR after the current date). I know how to make the [Alert Type] as a condition:

less(int(split(item()?['Alert Type'], 'Red')?[1]), int('4')) but I'm interested to know how to make the condition for if([Date] is equal to OR after the current date) and afterwards combine it with the condition of the [Alert Type] to if ([Alert Type] is greater than Red4) AND ([Date] is equal to OR after the current date). Any methods or techniques is appreciated, thanks in advance!

Categories:

Using connectors

I have the same question (0)

All responses (11)

Answers (0)

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Del-Dev ,

Please try this.

@and(less(int(split(item()?['Alert Type'], 'Red')?[1]), int('4')),greaterOrEquals(item()?['Date'], utcNow('dd-MMM-yy')))

Best regards,

Rimmon

Was this reply helpful? Yes No
Del-Dev 160 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-mengmli-msft,
Thank you for your suggestion! I have tried it but when I changed the date beside the "Red2" to "16-Jun-24", my expected outcome would be that I would not be able to print anything because both conditions: ([Alert Type] is less than Red4) AND ([Date] is equals to OR after the current date) and must be satisfied to print something. When I ran the flow in Power Automate, it still prints out something even I have changed the date to 16-Jun-24 and both conditions is not satisfied. Please advise me on this, thank you!

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Del-Dev ,

Could you please show some screenshots about your flow?

Here is my test. I think it works well.

The second item meets two conditions.

1.less than red4 .

2.greater than or equal to current date.

Best regards,

Rimmon

Was this reply helpful? Yes No
Del-Dev 160 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-mengmli-msft,
Below are the screenshots:

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Del-Dev ,

This is because we are using different date formats.

Your Date column is in dd-MM-yyyy format. Please modify date format in filter array.

Best regards,

Rimmon

Was this reply helpful? Yes No
Del-Dev 160 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-mengmli-msft,
Below is the screenshot of the format I have changed:

The date 15-06-24 is still printed:

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Del-Dev ,

What does the output of Date column in List rows in a table?

Please check if the format in Filter array is same to above.

Best regards,

Rimmon

Was this reply helpful? Yes No
Del-Dev 160 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-mengmli-msft,
The screenshot below is the output of List rows in table:

I have tried these formats that you have suggested earlier for the Filter Array:

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Del-Dev ,

Please turn on this setting.

Then use yyyy-MM-dd in filter array.

Best regards,

Rimmon

Was this reply helpful? Yes No
Del-Dev 160 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-mengmli-msft,
The Filter Array is working now, but I have an error for my "Select" action. Below is the screenshot of the error:

And the below screenshot is my "Select" action:

Was this reply helpful? Yes No