Power Platform Community Forum Thread Details

I am new to Power Apps. We are planning to create an application using Power Apps as follows:

Because the Power Apps Portal cannot connect to AZure SQL database and do the CRUD, here is what I can think of, but I don't know if it's doable:

Create a Power Apps Portal
Apply authentication and authorization by integrating Azure AD
Create Canvas App that connects to AZure SQL database and do CRUD operations
Embedded the Canvas App in iFrame in the portal (by just put the canvas app link in the iFrame)
Use the web roles to control the access to the page of the iFrame

Is this a possible solution? Any advice/comment will be greatly appreciated.

Thanks,

Categories: