Lots of PowerApps developers waste hours of their lives trying to figure out:
- What type of object am I dealing with
- What properties does a certain object have
One good solution would be to add a simple label where, in Text property we could specify something like Stringify(My_Object_OrArray)I hope it's not that hard to implement, but the amount of time we could save on debugging would be massive. Plus, passing JSON objects to MS Flows or other connectors would be extremely useful.
This is now complete. Check out the announcement in the blog, and the documentation for the new JSON function.
Couldn't agree more with 'Plus, passing JSON objects to MS Flows or other connectors would extremely useful'!
I totally agree, it will be of a great help. I am just starting "developping" in PowerApps, and indeed I am spending a lot of time wondering the type of expressions I am writing down.
It would even be better to have the possibility to select an expression in order to display its resulting type (in tooltip or in a specific place of the screen)
Same here. My needs are less about debugging then sending collections to Flow
Cannot image a programmer can live without that function at all. Please add this as soon as possible.
Thanks very much.
In the mean time, I've used a custom solution that works quite well.
You can forget the "IsDirty" flag, I'm simplly using this send only rows in my collection that have changed. I'm also doubling quotes in the C2 column with the substitute function because my client (Azure SQL DB) requires it to read them has text and not an end of sting character.
Hope this can help some :
I have used similar solution like below, but I am afraid the value part will contain some invalid characters that eventually break the whole json.
Need to send JSON to stored procedure to update multiple rows.
I've hand coded a messy concat() function to create a properly formatted JSON to pass to Azure SQL DB, but wow, very messay and lots of trial an error.
This gets my vote. How sadly lacking PowerApps is. Seems like a Beta product and we're all Beta testers. It wouldn't get my nod for release.