Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities - Lets Get Started!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / Write back to Azure SQ...
Power Apps - Microsoft Dataverse
Answered

Write back to Azure SQL DB from powerapps portal app

(0) ShareShare
ReportReport
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:
Entities
Dataflows
  • Verified answer
    v-siky-msft Profile Picture
    v-siky-msft on at
    Re: Write back to Azure SQL DB from powerapps portal app

    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

  • Community Power Platform Member Profile Picture
    Community Power Pla... on at
    Re: Write back to Azure SQL DB from powerapps portal app

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

  • v-siky-msft Profile Picture
    v-siky-msft on at
    Re: Write back to Azure SQL DB from powerapps portal app

    @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

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.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities - Lets Get Started!

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Microsoft Dataverse

#1
stampcoin Profile Picture

stampcoin 17

#2
mmbr1606 Profile Picture

mmbr1606 15 Super User 2025 Season 1

#3
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans