I've been asked by a customer to look into a powerapp that mixes sharepoint and azure sql, wich i've been hitting my head trying to figure it out if it's possible.
So what my client needs is a custom form that the salesmen can fill on premises with the clients, using their mobile devices. That data will be later used to generate reports using powerbi.
The powerapp should import data from sharepoint wich they are already using has a CMS for their product lines.
That data should be used create a form, with a couple of dropdownlists and multiple choices, wich then needs to be saved not on sharepoint, but into an Azure SQL database, for later reports.
Is this something that can be accomplished using powerapps, is there a better solution, any pointers you can throw at me?
Yes, this could be done under PowerApps.
For SharePoint List connection, check the article below for the known issues:
Connect from Microsoft PowerApps to SharePoint
For SQL Server, check:
Connect from Microsoft PowerApps to SQL Server
If this is the first time that you work with PowerApps, the nyou may start from the guide below:
Generate an app(SharePoint List)
For form controls, check:
Understand data forms in Microsoft PowerApps
Edit form and Display form controls in PowerApps
I fully concur with @v-micsh-msft
However you should also be aware of current bugs/limitations in the Azure SQL connection from PowerApps:
1) After a field contains a value, you cannot set the value back to null from PowerApps
2) There are intermittent issues writing numbers with more than 7 significant figures to the database
3) Date type columns cannot be filtered using > or < operators
4) Writing to date type columns is problematic
Happy to provide more details to any of the above.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.