Action 'Apply_to_each' failed

[kristinamariz]

Hi,

I'd be needing your expertise regarding my concern.

I have a flow based from this link. When I run the flow, I'm getting this error on the 'Apply to each' action:

The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@body('Parse_JSON')?['value']' is of type 'Null'. The result must be a valid array.

Kindly advise. Thanks!

[FrankBZero]

If anyone has any suggestions or indeed another approach to displaying appended text (from a SharePoint list) in a PowerApp I would be grateful. Thanks 

[VictorTek]

Hello @kristinamariz @fchopo @FrankBZero!

Looks like I am in the same boat. Any guidance will be highly appreciated.

I have a created Power Automate based from this link. When I run the flow, I'm getting this error on the 'Apply to each' action:

ExpressionEvaluationFailed. The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@body('Parse_JSON')?['d']?['query']?['PrimaryQueryResult']?['RelevantResults']?['Table']?['Rows']' is of type 'Null'. The result must be a valid array.

I have tried following steps from Solved: Re: Action 'Apply_to_each' failed - Power Platform Community (microsoft.com) However it did not help.

My Flow is picking the inputs from PVA bot and should respond back to PVA as well. (Post a message to MS Teams is just an additional for testing).

Overall Flow as below.

For Compose I have used below:

Title: setProperty(variables('ResponseJson'),'Title',items('Apply_to_each_2')?['Value'])

Path: setProperty(variables('ResponseJson'),'Path',items('Apply_to_each_2')?['Value'])

For output (printing to Teams or back to bot I am using: 

variables('ResponseArray')

 

[fchopo]

Hi @VictorTek 

Please, review the schema in the "parse json" action. In that schema you should see that ['RelevantResults']?['Table']? should be an optional field.

Hope it helps.

Ferran

[tandey]

try with '@body('Parse_JSON')['value']' and it will work, you need to remove the ?

[tandey]

@body('Parse_JSON')?['value'] without ? is your answer

[Anonymous]

1. Which reply is correct? This or the 12:28 one?

2. How do you edit the value of the For Each variable??