Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Michael Seto]

If I have a SharePoint field which contains multiple key/value pairs in JSON format, does PowerApps have the native capability to be able to parse values from that field? Ideally, I’d like to be able to do this ::

SharePoint Field value ::

{
“name”: “michael”,
“title”: “cloud wiz”
}

PowerApps Labels ::

Label1.Text = “Name: ” & ParseJson(SharePointField.name)
Label2.Text = “Title: ” & ParseJson(SharePointField.title)

Thanks for your help!

——————————
Michael Seto
Cloud Wiz
——————————

[Nick Miller]

Hello, 
You don’t have to parse json in power apps.  That syntax is how you manually create a table or collection in power apps.  That sp list column value is basically a table.  If the gallery is each sp list item, click it and populate that row in a form, for your label and value would be 

Label1.text =  First(thisitem.SharePointColumn).name

Label2.text =  First(thisitem.SharePointColumn).title

This gets the first row (only row) of the table in that sp column.  Putting the .name after the “first(…)” will return that value as a string, rather than a table.  
Let me know if that solves your issue.

——————————
Nick Miller
Premier Field Engineer
Altamonte Springs FL
——————————
——————————————-

[Michael Seto]

Hey Nick,

Not sure about what you’re looking for me to try. As a test, I created a text field (TextInput1) and entered the JSON from above as its value. I created a label (Label1) and tried to set its default text to what you suggested, First(TextInput1).name but got errors:

Invalid argument type (Control). Expecting a table value instead.

Invalid use of ‘.’

——————————
Michael Seto
Cloud Wiz
——————————
——————————————-