Announcements
How can i do thisI used to send the Forms to SQL directly without any intermediate, but now my bosses are asking methat when de data is send it has to transform to JSON and then send it to an intermediate that transform it again, o now it can be added to the SQL Table.They say it is for security reasons thta the data must be in JSON formatit can be done with a flow or something like that
There is a built in JSON function that converts objects to JSON. Here is an example of setting a variable to a JSON value of a collection:
Set(jsonString,JSON(yourCollection));
---If this answered your question, please click "Accept Solution". If this helped, please Thumbs Up.
AND HOW DO I VALIDATE THAT DATA?
What do you mean exactly? Like check that it's a valid JSON schema? Or validate that the values are correct?
Both options
I've never run into any reason to doubt the conversion has produced an invalid schema or incorrect values. You can use a validator like the one below to run some tests, but everything should be valid.
https://jsonlint.com/
is it possible to validate with a button in powerapps or connect a service to powerapps that validate the JSON
I don't know that the JSON() function is capable of producing invalid JSON schemas. I have never had a problme with an invalid schema from the function. To answer your question, there may be a way to validate it using Power Automate, but I'm not sure. You can post that question on their forums here if you'd like
https://powerusers.microsoft.com/t5/General-Power-Automate/bd-p/MPAForum
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 541
WarrenBelz 434 Most Valuable Professional
Valantis 289
