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?
