cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Luismvm
New Member

Power App with Sharepoint + Azure SQL

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? 

2 REPLIES 2
v-micsh-msft
Community Support
Community Support

Hi @Luismvm,

 

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

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Meneghino
Community Champion
Community Champion

Hi @Luismvm

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.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,060)