web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Passing Arguments (Inc...

Power Apps - Building Power Apps

Answered

Passing Arguments (Including Array) to PowerAutomate Flow as JSON

Like (1) Share

Report

Report

Posted on 5 Jun 2023 20:35:43 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.

All responses Img

All responses (6)

Answers Img

Answers (1)

Community Power Pla... on 07 Jun 2023 at 15:02:03

Like (1)

Report

Re: Passing Arguments (Including Array) to PowerAutomate Flow as JSON

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

Pstork1 67,176 Most Valuable Professional on 06 Jun 2023 at 23:52:26

Like (2)

Report
Re: Passing Arguments (Including Array) to PowerAutomate Flow as JSON

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

PowerAppsInput, { AssignedTo: AssignedToList } )
Community Power Pla... on 06 Jun 2023 at 19:54:20

Like (1)

Report

Re: Passing Arguments (Including Array) to PowerAutomate Flow as JSON

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.
Pstork1 67,176 Most Valuable Professional on 06 Jun 2023 at 19:39:49

Like (1)

Report

Re: Passing Arguments (Including Array) to PowerAutomate Flow as JSON

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.
Community Power Pla... on 06 Jun 2023 at 18:16:24

Like (1)

Report

Re: Passing Arguments (Including Array) to PowerAutomate Flow as JSON

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.
Pstork1 67,176 Most Valuable Professional on 05 Jun 2023 at 22:05:15

Like (2)

Report

Re: Passing Arguments (Including Array) to PowerAutomate Flow as JSON

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.