Condition for negative values in excel table

[stefbworld]

Hi there Experts!

Having trouble creating a condition action to screen for negative values within an excel table from an excel attachment

Using list rows present in a table I am trying to create two conditions for an excel attachment:

1. If there are any blank values in the table, then send email 1, if not proceed to condition 2

2. If there are any negative values in the table column Var% and Var%4, then send email 2, if not copy paste all table rows as new rows into an excel file in OneDrive

Am currently stuck on Condition 2, I can get it to detect negative values in the first row, but not the subsequent rows. 
This is my current flow + expressions

float(items('Apply_to_each')?['Var%'])

empty(items('Apply_to_each')?['New'])

[SanmeshG]

Hi @stefbworld ,

You can try using filter array instead of condition , this will be a much better option. So you can write the filter array twice , or you can use an and condition inside the filter array.

Hope this helps!

Thanks,

Sanmesh

[stefbworld]

Hi @SanmeshG thank you for your reply! Could you show me an example flow to use the filter array?

Still new to power automate 🙂

[SanmeshG]

Hi @stefbworld ,

Please refer the below image. First filter the array based on the column for which you want the value to be non null. Then use the filter array action in Power Automate to filter the array where it has positive values.

I have used a column New in my excel to filter non-null values (list rows present in a table action), use the column name from your excel.

Use the below expression to filter the array to get only positive values. Here New and New2 refer to the column names in my excel. Change the column names in the below expression as per your excel sheet and paste the formula , by clicking on Edit in advanced mode in Filter Array action.

@And(greater(float(item()?['New']), 0),greater(float(item()?['New2']), 0))

If this helps do give it a thumbs up and accept it as a solution.

Thanks,

Sanmesh

[stefbworld]

Thanks! What code should I use if I want to filter for empty cells? (i.e. to check if there are empty cells in a column)

[SanmeshG]

Hi @stefbworld ,

Please use the filter array operation and and use the condition is not equal to and write the expression null.

Hope this helps , please accept this as a solution and give this a thumbs up to help other community members.

Thanks,

Sanmesh

[stefbworld]

Hi Sanmesh! Thank for the help!

Could I ask how I should write the expression if I want it to be an OR expressions instead of an AND expression? What output should I get from the filter so I can continue with the rest of my flow?

Thanks!

[stefbworld]

@SanmeshG  Getting this error when I try to check for empty values, any suggestions?

This is the expression: @Anonymous(equals(string(item()?['Country / Region'], null),equals(string(item()?['XXX Business Units']), null),equals(string(item()?['Supplier ID']), null),equals(string(item()?['XXX SKU ID']), null),equals(string(item()?['Brand']), null),equals(string(item()?['Product Description']), null),equals(item()?['Requested Cost Effective Date'], null),equals(item()?['Requested RSP Effective Date'], null),equals(string(item()?['Currency']), null),equals(float(item()?['New']), null),equals(float(item()?['Current']), null),equals(float(item()?['New2']), null),equals(float(item()?['Current3']), null))