Unanswered

How to check empty output from Select Action

(1) Share

Report

Posted on by Community Power Pla...

I've a SharePoint List where it contains items.

I used the Get Items in order to pull some data from my SharePoint list and I use OData Filter to select specific records.

After that, I use Select in order to select specific items from the output in the previous step.

Now, I wish to put a condition that will check whether the output is empty or not.

My flow is below

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Mitanshu 1,650 Moderator on at

Like (1)

Report

Select action will give you an array.
You can use expression length(ARRAY) to get number of elements in an array.

So in this case, use condition length(ARRAY) is equal to 0.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Verified answer

poweractivate 11,078 Most Valuable Professional on at

Like (2)

Report
@Anonymous

Try one of these two ways. Assuming an array of interest is inside 'Compose 2' (but you can easily just use the body or body/value output of Get items instead in these expressions - whichever is appropriate for your case):

empty(outputs('Compose_2'))

is equal to

true

or

length(outputs('Compose_2'))

is less than 1

Replace the example of outputs('Compose_2') in the above with the output of Get Items. This would be something like either outputs('Get_Items')?['body'] or outputs('Get_Items')?['body/value'] - use what works correctly here for your use case.

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

Like (0)

Report

How can I find the name of the array that results from "Get Items" action?

Was this reply helpful? Yes No
Mitanshu 1,650 Moderator on at

Like (1)

Report

@Anonymous wrote:
How can I find the name of the array that results from "Get Items" action?
outputs('Get_items')?['body/value']

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No