Answered

Apply to Each Issue

(0) Share

Report

Posted on by Jimmyqwe

Hello. I am having issues trying to create a flow connected with Virtual Agent.

Request to XRM API failed with error: 'Message: Flow client error returned with status code "BadRequest" and details "{"error":{"code":"InvalidOpenApiFlow","message":"Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'Return_value(s)_to_Power_Virtual_Agents' at line '1 and column '1731' is invalid. Action 'Apply_to_each' must be a parent 'foreach' scope of action 'Return_value(s)_to_Power_Virtual_Agents' to be referenced by 'repeatItems' or 'items' functions.'.'."}}". Code: 0x80060467 InnerError: '.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

Amit_Sharma 1,569 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Jimmyqwe

Current item also returns current value of array which array iterate in apply to each action. and the scope of current item action also only in apply to each action so that's why you have getting error.

If you want to get current item of array you can use Initialize variable outside the apply to each and use append to array variable action inside the apply to each and pass current item value in append to array variable action.

--------------------------------------------------------------------
If I have answered your question, please mark post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Amit_Sharma 1,569 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Jimmyqwe

Please Confirm the Get item value always return only one value according to your filter if is ok then you don't need to use apply to each you can directly return value to power virtual agent.

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report
Copy link

Link copied!

If you knew you were only getting a single value back from SharePoint, you could just move your Return value(s) to Power Virtual Agents into the Apply to each (which will only run once for the single item) and use the output from the Compose.

----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
CasualFan 2 on at

Like (0)

Report
Copy link

Link copied!

Thank you, Amit. I still am having issues. The flow will now save but the return I get in virtual agent is only [ ]. Also, based on the filter there will be only one item returned, but in the return to agent value, i do not want all the item data, just a few specific columns.

Was this reply helpful? Yes No
Jimmyqwe 8 on at

Like (0)

Report
Copy link

Link copied!

Thanks, I get the following error message.
Request to XRM API failed with error: 'Message: Flow client error returned with status code "BadRequest" and details "{"error":{"code":"InvalidOpenApiFlow","message":"Flow save failed with code 'InvalidWorkflowRunAction' and message 'The workflow run action 'Return_value(s)_to_Power_Virtual_Agents' has type 'Response' that could not be nested under an action of type 'foreach'.'."}}". Code: 0x80060467 InnerError: '.

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report
Copy link

Link copied!
@JimmyqweSorry, didn't realize it would do that. In that case you can just move your Return value(s) to Power Virtual Agents out of the Apply to each (as you did before) but add the following expression to retrieve the value from your Compose.

first(outputs('Compose'))

----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No