Unanswered

Problems testing for empty result from Excel - List Rows present

(0) Share

Report

Posted on by Community Power Pla...

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!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

v-bacao-msft on at

Like (0)

Report
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,

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (0)

Report

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,

Was this reply helpful? Yes No