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

Collect works when hard coded into the function, but not when the exact same value is pulled dynamically

I have populated a text field with a JSON schema in SharePoint as a multi line plain text field and would like to use that for a collection.  When I pull in the value dyanmically i.e. 

CollectionFromField.JPG

It treats the collection as a single item
collectionSingleValue.JPG

If I paste in the exact text which is returned from my Approval Record field, it works as expected.
CollectionHardCoded.JPG
CollectionHardCodedCorrect.JPG

 

What am I doing incorrectly or am I missing something?

1 ACCEPTED SOLUTION

Accepted Solutions
dtadam123
Frequent Visitor

@timl Thank you for confirming my suspicions, I will mark your reply as the answer.  It is extremely frustrating that everything useful in Flow seems to be hidden behind a premium connector.  If we were able to return Arrays to PowerApps without having to utilize the premium Response connector I would be much happier.  I spent a bunch of time trying to get around having to pay for the Common Data Service premium connector by storing/bulding this as JSON myself, but it seems that Microsoft thought of how to prevent these workarounds.  I am starting to understand why every Flow example I have seen is so simple and not realistic.

Anyways sorry for the mini rant and thank you for the response!

View solution in original post

2 REPLIES 2
timl
Super User
Super User

Hi @dtadam123 

Unfortunately, it isn't possible to parse JSON in this way. There was a post about this the other week which you might be interested in.

https://powerusers.microsoft.com/t5/Building-PowerApps-Formerly/Parse-JSON-string-in-Power-APPS/m-p/... 

A workaround would be to use Flow. There's also a post in the Ideas forum that you can vote on.

https://powerusers.microsoft.com/t5/PowerApps-Ideas/Parse-JSON-in-PowerApps/idi-p/359563 

dtadam123
Frequent Visitor

@timl Thank you for confirming my suspicions, I will mark your reply as the answer.  It is extremely frustrating that everything useful in Flow seems to be hidden behind a premium connector.  If we were able to return Arrays to PowerApps without having to utilize the premium Response connector I would be much happier.  I spent a bunch of time trying to get around having to pay for the Common Data Service premium connector by storing/bulding this as JSON myself, but it seems that Microsoft thought of how to prevent these workarounds.  I am starting to understand why every Flow example I have seen is so simple and not realistic.

Anyways sorry for the mini rant and thank you for the response!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (1,959)