cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

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

5 REPLIES 5
Rebetcha
Level 10

Re: Passing complex Objects and Collections from PowerApps to MS Flow?

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

Re: Passing complex Objects and Collections from PowerApps to MS Flow?

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.

Rebetcha
Level 10

Re: Passing complex Objects and Collections from PowerApps to MS Flow?

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.
Rebetcha
Level 10

Re: Passing complex Objects and Collections from PowerApps to MS Flow?

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
svijay_001
Level: Powered On

Re: Passing complex Objects and Collections from PowerApps to MS Flow?

@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.