cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Kudo Kingpin
Kudo Kingpin

Passing complex Objects and Collections from PowerApps to MS Flow?

Is there a way to pass Complex objects from PowerApps to MS Flow?

 

I've seen some strange suggestions to create a sting by concatination and pass to to MS Flow. Is this still the case is there no way to pass objects to Flow?

 

For example, we need to pass an array of 40 objects to MS Flow and every object looks like this:

 

{ FullName:"Denis Molodtsov",
  RequiredEmail: true,
  ProjectID: 122
}

 

Does anyone have any elegant solutions for this task? Any helps is greatly appreciated!

 

ComplexPowerAppObject.pngComplexPowerAppObject 2.png

6 REPLIES 6
Highlighted

Great question. I am not sure to be honest. Have you tried out your suggestions? What were the results?
Highlighted

Well, the only suggestion that I've seen is to iterate through all objects and properties and concatenate a long string. Then pass this string to a Flow. Then, inside MS Flow I need to parse that string manually.

 

I'm sure most developers will agree that it sounds like a very ugly suggestion. Stone-age-like solution. I'm going to start implemeting it tomorrow if there is no other way. But before doing it, I wanted to make sure that I'm not doing something stupid. If I could just pass objects to MS flow, I would really like to do it.

Highlighted

Unfortunatly I think you are right. I tried several options, but as soon as I added an action with an array input in a Flow where I wanted to get the array from PowerApps the adding of the Flow to PowerApps failed.
Instead of using the long string I think I would save the array as a table in a temporary datasource (could be a SharePoint list) and use that datasource in your Flow. Makes updating the Flow as soon as there is some good way to pass an array to your Flow easier.
Highlighted

Maybe found something. You could have a look at the concat function. According to the formula description "The Concat function concatenates the result of a formula applied across all the records of a table, resulting in a single string. "
In Flow you still have to parse the string, though.
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-concatenate
Highlighted
Microsoft
Microsoft

@DenisMolodtsov  

 

I was able to get this done by using the JSON method in  powerapps. I have detailed it on the below article :

 

Pass Power Apps collection to Flow

 

The idea is to have  the collection converted to JSON and parse the JSON object at the Flow end like any other JSON Object.

Highlighted

The link @svijay_001 provided is sending me to what seems to be an unrelated post (i.e. https://powerusers.microsoft.com/t5/General-Discussion/powerapps-and-planner-task/td-p/47785 ).  This post ( https://powerusers.microsoft.com/t5/General-Discussion/Passing-the-PowerApps-Collection-to-MS-Flow/m... ) seems to be the one svijay_001 is referring to.  Regardless, thanks @svijay_001 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (3,446)