Announcements
Hi Team,
I want to insert output of my data which is in JSON format into CDS. How can I achieve that?
Thank you in advance.
Hi @Anonymous ,
Can you clarify a bit your requirement? Do you want to store a JSON in CDS as a string in the CDS or what? If yes then you can just create a multiline text field on the entity and store data their (just don't forget that you have a maximum number of characters in the field).
So I have output something like as shown in the image after particular user logged in. And I want to store data in the form of table. for ex- in the image I have two field under DATA section i.e. answers and evidence. I want that data to be store in table as a single row for the logged in user under respective columns.
Please let me know if you need more clarification.
Thank You.
i think, the easiest way would be to create a form with at least the required fields to fill in, create an entityform out of it, then add some javascript to the entityform to call the service and place the responsefields in the corresponding fields in the entityform and click submit ( $("#submit").click() should do the job )
You can also create an invisible iframe on a page where you need this, load the form there and write some gluecode to send data to the iframe via postMessage.
Another possibility is to create a textfield on your (or another...) entity, just write the stringified json object and write a plugin which does all the dirty stuff which could be needed 🙂
Both (the text-json ist just a small variation of the preceding two) should do the job, we did both in some projects.
But: there will/should/could/... be a new feature to be visible in june ( https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave1/microsoft-powerapps/planned-features#power-apps-portals-improvements ) : CRUD operations for portals ( https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave1/microsoft-powerapps/web-apis-crud-operations-common-data-service-entities ) . This should make these kind of tasks muc miuch more easy.
Hope this helps,
Christian
You can now store files directly into Dataverse using File columns.
File columns (Microsoft Dataverse) - Power Apps | Microsoft Docs
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.
Valantis 49
11manish 33
Haque 28
