Unanswered

Passing Arguments (Including Array) to PowerAutomate Flow as JSON

(1) Share

Report

Posted on by Community Power Pla...

Hello!

I have a PowerAutomate Flow that I want to pass more than twenty arguments into from PowerApps. I am trying to accomplish this by passing them all as a JSON string, as explained in this post: https://powerusers.microsoft.com/t5/Building-Power-Apps/Power-App-data-to-Automate-More-than-20-inputs/td-p/1825812

What's making things tricky is that one of my inputs is multi-select/an array of email addresses. I've been referencing this forum post as well to try to figure out how to deal with that: https://powerusers.microsoft.com/t5/Building-Power-Apps/Pass-multi-person-field-value-as-parameter-to-Flow/td-p/445632

Here's what I have so far. I don't think I'm too far off, but I just can't quite figure it out. Any help would be greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Pstork1 68,697 Most Valuable Professional on at

Like (2)

Report

YOu are very close. But you don't need the JSON() function in the Parse JSON. Just use the string you get from the Trigger and then after running it once use the output from the trigger to generate the schema in the Parse JSON.

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

Like (1)

Report

Thanks to your help, I was able to make significant progress. However, I'm struggling to take the email addresses from PowerApps and put them into an array for use in my PowerAutomate flow. I would greatly appreciate any insights as to how to accomplish this.

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (1)

Report

The easiest way to create an array that you can pass as JSON to the flow is to create a Collection. When you put the collection inside JSON() it will become a JSON array when received in the flow. If you create a collection and add that as a property to an object you'll get what you are looking for.

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

Like (1)

Report

Please forgive my ignorance, but I thought I had already created a collection to pass to the flow:

ClearCollect(AssignedToList,{assignee: CR_ASSIGNEDTO_Value.SelectedItems});

Set(
PowerAppsInput,
{
AssignedTo: JSON(AssignedToList,JSONFormat.IgnoreBinaryData),
}
)

I think my issue may be accessing the array within the flow properly, rather than passing the array to the flow, but I could very well be wrong.

Was this reply helpful? Yes No
Verified answer

Pstork1 68,697 Most Valuable Professional on at

Like (2)

Report
I don't think you want to translate the collection using JSON() when adding it to the variable.

PowerAppsInput, { AssignedTo: AssignedToList } )

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

Like (1)

Report

You're exactly right. Thank you very much for all of your help.

Was this reply helpful? Yes No