Problems testing for empty result from Excel - List Rows present

[Anonymous]

I am trying to write a simple flow which looks to see if a row containing a key item exists, and if not I will add a new row.

I wrote an Odata filter in List Rows Present to search on the incoming key data. If the key value is not found, I get an empty body from List Rows Present. I have tried creating a Condition to test for Null in tons of ways:

equals(triggerbody(), null) = true

trigger() = null

triggerFormDataValue('value') = null

and *many* other variations. 

Any suggestions would be greatly appreciated!

[v-bacao-msft]

Hi @Anonymous ,

You could use length() function to get numbers of the filtered rows.

Expression reference:

length(body('List_rows_present_in_a_table')?['value'])

Image reference:

Best Regards,

[Anonymous]

Thank you, this was very close! Because length() wanted a string, I used the following:

length(string(body('List_rows_present_in_a_table')?['value']))

And, since Body contained "value: []" the returned length was 2, presumably for the square brackets.

So, I modified the Condition to compare the above length string equal to 2 and it works!

[v-bacao-msft · Accepted solution]

Hi @Anonymous ,

If it is an array, you can also use length() to determine the number of array elements. The current Body returns an empty array, so we can use the method I provided directly.

Best Regards,