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.
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?
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!
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.
See question below posted by @archanan