Creating a UI form in azure to insert or update data in sqldb on azure

[shdewan73]

Hi,

I am looking for a way to create a UI form on azure to insert or update data in sqldb on azure db.is there any azure service to achieve this functionality.Please advise.

Thanks,Shatamjeev

[#2]

Hi @shdewan73 ,

I don't believe there is an Azure service that would allow you to build such for as out-of-the-box capability.

There are several options requiring you to build a custom solution:

• Power Apps - this is low-code / no-code service (part of the Power Platform), where you could author the GUI (your form), publish it to your users, and integrate it in the backend with e.g. Power Automate (formerly known as Flow), Logic Apps or similar to process those requests. You can build an interactive app with it, not just a simple form. More info: https://powerapps.microsoft.com/en-us/
• Microsoft Forms - no-code option, allows to create a form (typically used for polls, quizzes), but if you need something simpler that Power Apps, this could work. You can also integrate it with Logic Apps or Power Automate - https://docs.microsoft.com/en-us/connectors/microsoftforms/
• Create a simple web app (requires some web development skills) and host it e.g. in Azure Static Web Apps (https://azure.microsoft.com/en-us/services/app-service/static/) or in Azure Storage as static websites (https://docs.microsoft.com/en-us/azure/storage/blobs/storage-blob-static-website) and integrate it with Azure Functions to process requests in the backend.

Each option might require different licenses and skills to leverage them.