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:
Hi @Del-Dev ,
As soon as you have turned on the ISO8601 in List rows in a table, there is no need to use addDays to convert serial number to ISO8601, please remove it.
——————————————————————————————————————————————————
If my answer helps you solve the problem, please accept it as a solution.
If you have another question, please post it in new post.😀
Best regards,
Rimmon
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:
Hi @Del-Dev ,
Please turn on this setting.
Then use yyyy-MM-dd in filter array.
Best regards,
Rimmon
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:
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
Hi @v-mengmli-msft,
Below is the screenshot of the format I have changed:
The date 15-06-24 is still printed:
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
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
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!