cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

PowerApps Collection via Flow into JSON

Hi Folks,

Struggling to get this to work for an item that has multiple values. I have a collection in PowerApps that contains "SiteName" and "SiteURL". Im trying to pass these values into Flow so I can create a SharePoint List item and pass them onto an Azure Queue in JSON for each item in the collection.

 

I can get in to work for either "SiteName" or "SiteURL", but not both combined. I'm not sure how to split the string when there's two fields in the string that are being passed to Flow - any suggestions?


Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Frequent Visitor

Re: PowerApps Collection via Flow into JSON

Hey,

Yeah I eventually got it working after a lot of trial and error....

 

Think in total I've got 6 or 7 different steps to transform the string back into JSON then parse it to get the values out. Hopefully there's something in the works to make it easier in the future!

 

The compose kept adding '\' back into the split value... which threw me

View solution in original post

4 REPLIES 4
Highlighted
Impactful Individual
Impactful Individual

Re: PowerApps Collection via Flow into JSON

At the moment, PowerApps doesn't naitvely support passing record values to Flow, it only supports passing string values.  To handle this you'll have to do a work-around and do some string manipulation on the Flow side.  If I'm understanding your need correctly I think this solution is helpful:  https://powerusers.microsoft.com/t5/General-Discussion/How-to-supply-a-record-parameter-to-Flow-from...

 

Check out the marked solution and look at the work-around that is supplied and let me know if that helps.

Highlighted
Frequent Visitor

Re: PowerApps Collection via Flow into JSON

Hey,

Yeah I eventually got it working after a lot of trial and error....

 

Think in total I've got 6 or 7 different steps to transform the string back into JSON then parse it to get the values out. Hopefully there's something in the works to make it easier in the future!

 

The compose kept adding '\' back into the split value... which threw me

View solution in original post

Highlighted
Impactful Individual
Impactful Individual

Re: PowerApps Collection via Flow into JSON

Yeah it does require several steps to get the data manipulated correctly.  I hope it's something they are working on improving.  Glad you got it working!

Highlighted
Community Support
Community Support

Re: PowerApps Collection via Flow into JSON

Hi @Blair24,

 

It seems that your problem has been solved.

If yes, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

 

Best regards,

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Users online (6,860)