Have a way to take a custom connector that produces a JSON response and parse it into individual peices. As a workaround, provide a function to take a JSON response and extract values.
See question below posted by @archanan
Hi - can you provide some more details around this ask? An example of what you are trying to accomplish would be helpful.
Hi @Audrie-MSFT - maybe @pturner was asking for is similiar to the Split function. The Split function converts a delimited string into a single-column table. Can we have a new function that can convert JSON text/string to multi-column table?
There is a connector in flow that will parse a JSON object. If you select the Parse JSON action in Data Operations.
I would very much like an ability to parse JSON within PowerApps, too.
My use case would be to store table-like data in SharePoint lists.
It would be great to be able to create a Record from a JSON string received from a Flow for example. In fact, the exact opposite of the new JSON() function that creates a JSON string from an object. @Audrie-MSFT maybe something exists already ?
It would be superb if I could build a collection from JSON formatted text.
Like ClearCollect(colMyCollection, varJSONtxt)
Where varJSONtxt is a string containing JSON formatted text. With this feature, it could be possible to store collections into SharePoint list text column as JSON. And load data back to PowerApps!
Is there any update on this?
Also curious if there's an update on this. I have a few instances in one of my apps which generates my JSON content in seconds, but spend 20+ minutes update the records in SharePoint. If this was just a JSON string, I could update a single multiline text record in SharePoint in seconds to meet my needs.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.