Unanswered

Write back to Azure SQL DB from powerapps portal app

(0) Share

Report

Posted on by Community Power Pla...

Dataflow in PowerApps helps us to bring the existing data from Azure Sql along with the schema into CDS. From the App in a day lab materials, I understand, that I will be able to create entity form for CRUD operation and the data which is entered from the UI gets stored in the CDS. This usecase scenario is common in model driven apps and is consumed inside dynamics 365 portal or power apps portal. But in the case of Power Apps portals which are public facing, that would be having several requirement to insert and update data inside an enterprise database (Azure Sql, Oracle etc) - ie., CRUD operation on user database not the metadata database (ie., CDS).

My Question is, how can we perform the CRUD operation from powerapps portal and write the data into azure sql, which will be consumed by other different services across the organisation. We assume forms created using canvas apps cannot be consumed in Portal apps, and we can only use entity forms (which are model driven) in Portals, please validate my assumptions.

Please share me any material that you have for Power Apps portal similar to App in a day material.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

v-siky-msft on at

Like (0)

Report

@Anonymous

I am afraid your requirement that performs the CRUD operation from powerapps portal and write the data into azure sql is no available in PowerApps portals. Not only portal but also Model-driven Apps.
From the description of PowerApps portals, we can know that the users can only create and view data in Common Data Service.
Reference: https://docs.microsoft.com/en-us/powerapps/maker/portals/overview
Sik

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

Like (0)

Report

Thanks for your response, what is your recommendation to share the data captured within the CDS for downstream consumption and processing.

Was this reply helpful? Yes No
Verified answer

v-siky-msft on at

Like (0)

Report

Hi @Anonymous

Yes, CDS is the only data source that the Portal can write back.
If you want the portal could be able to write back to Azure SQL DB, please submit an idea to PowerApps ideas Forum.
https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas
If this reply has answered your question or solved your issue, please mark this question as answered.
Sik

Was this reply helpful? Yes No