Unanswered

The output you selected is inside a collection and needs to be looped over to be accessed.

(0) Share

Report

Posted on by raoraheel

I am working on creating a flow which gets a list using D365 Finance entity. I am limiting the query to get me top 1 record and need to grab value of single object and pass back to PowerApp.

When I us 'Respond to a PowerApp or Flow' to pass that value, I get this error below.

The output you selected is inside a collection and needs to be looped over to be accessed. This action cannot be inside a foreach.

What will be the way to grab that value and pass to powerapp without running into this error? In screenshot below, 'Balance' value is what i want to grab.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

MJain 2,450 on at

Like (0)

Report

Hi @raoraheel ,

In order to use the Balance field value from the output returned

outputs('YourActionName')?['body/value/Balance']

your action name should be replaced with "List Items present in table"

Thanks

Was this reply helpful? Yes No
Ed Gonzales 4,531 Most Valuable Professional on at

Like (0)

Report

@ManishJain - I wonder if even though there is only one result, that it being in an array is triggering the error? Not sure, but @raoraheel if you still get the error, try putting Manish's expression in a compose before returning it to PowerApps, but wrap the thing in a first() - something like this: first(outputs('YourActionName'))?['Balance']

Essentially, you might need to use the same tricks @benitezhere uses in this video:

Keep us posted.

-Ed

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Was this reply helpful? Yes No
Verified answer

MJain 2,450 on at

Like (0)

Report

Hi @raoraheel ,

Since this is list records it returns array . sorry my bad I hit the enter soon realizing that first should be used

first(outputs('YourActionName')?['body/value'])?['Balance']

Thanks

Was this reply helpful? Yes No
raoraheel 90 on at

Like (0)

Report

@ManishJain I get this error when I use that. Do you see what i'm doing wrong?

outputs('Lists items present in table')?['body/value/Balance']

Was this reply helpful? Yes No
raoraheel 90 on at

Like (0)

Report

This worked! Thanks Manish!

Was this reply helpful? Yes No
sandile7003 2 on at

Like (0)

Report

I am working on creating a flow which get values from an AI builder that extract information from invoices. I want to get values and use it in my power apps application. But then I encounter an error when I try to get the description of the invoice.

The error is "The output you selected is inside a collection and needs to be looped over to be accessed. This action cannot be inside a foreach."

and I am stuck on how to fix the issue. Please help

Was this reply helpful? Yes No