Unanswered

How to do CRUD operations on CDS from portal

(0) Share

Report

Posted on by Community Power Pla...

Hi All,
I am trying to create a editable grid/table having CDS as data source. And, I am using that grid/table in portal. My question is how can we insert or update or read the data from CDS using any API service?
What I know is we can read data using fetchXML and update/insert using powerautomate.
Any help will be appreciated

Categories:

Power Apps portals

I have the same question (0)

All responses (4)

Answers (0)

oliver.rodrigues 9,368 Most Valuable Professional on at

Like (1)

Report

Hi @Anonymous

That's a huge coincidence, just yesterday I wrote a blog post on editable grid using the new (in preview) Web API: https://oliverrodrigues365.com/2020/10/06/power-apps-portals-going-beyond-with-portals-using-web-api/

The post above was based on a local presentation I did last week, but you can still use the code, please let me know if you face any issues.

Basically Microsoft has a new Portals Web API that you can check the documentation here: https://docs.microsoft.com/en-us/powerapps/maker/portals/web-api-overview

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
OOlashyn 3,496 Most Valuable Professional on at

Like (1)

Report

Hi @Anonymous ,

You can use Portal Web API. It is still in preview so I would be careful before using it in Prod. It will be GA in February 2021. You can find mode about Web API in official docs. Regarding editable grid - you can check out my post where I provide example of creating excel like editable table, blog post from @OliverRodrigues where he shows example of editable grid and post from Nick Doelman with his example.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @OliverRodrigues,
That's awesome. Thank you .

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @OOlashyn ,
Thank you for the reply

Was this reply helpful? Yes No