cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Sharepoint form and SQL connection

Hello.

I made a Sharepoint form with power apps in wich I connect it to sql to display some information within the from. For me and some user the connection works an the filter to the table is made, to others it does not show any information in the table. Any help or suggestion on what to look for to solve this issue would be great. thanks!

2 ACCEPTED SOLUTIONS

Accepted Solutions
yashag2255
Dual Super User II
Dual Super User II

Hey @Anonymous 

 

Can you please confirm that the user who are seeing this issue, have appropriate roles on the App, Sharepoint and SQL Server? Also, what is the expression that you have used to filter out the results?
 
Hope this Helps!
 
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

v-xida-msft
Community Support
Community Support

HI @Anonymous ,

Could you please share a bit more about your scenario?

Do you custom a form within your SP List using PowerApps? Which SQL Server do you connect to from your app? On-Premises SQL or Azure SQL?

Further, could you please share a screenshot about this issue?

 

Please check if the other users (who faced this issue) have enough permission to access your SP List. In addition, please check if the other users have owned a proper PowerApps licenses.

 

If you added the On-premises SQL Server table as data source in your custom form app, the end users must own PowerApps Plan 1 license at least to access your custom form app. Currently, the On-premises data connector is not available for Office 365 license includes PowerApps.

 

More details about licenses supported in PowerApps, please check the following article:

https://docs.microsoft.com/en-us/power-platform/admin/pricing-billing-skus

 

Best regards,

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

View solution in original post

2 REPLIES 2
yashag2255
Dual Super User II
Dual Super User II

Hey @Anonymous 

 

Can you please confirm that the user who are seeing this issue, have appropriate roles on the App, Sharepoint and SQL Server? Also, what is the expression that you have used to filter out the results?
 
Hope this Helps!
 
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

v-xida-msft
Community Support
Community Support

HI @Anonymous ,

Could you please share a bit more about your scenario?

Do you custom a form within your SP List using PowerApps? Which SQL Server do you connect to from your app? On-Premises SQL or Azure SQL?

Further, could you please share a screenshot about this issue?

 

Please check if the other users (who faced this issue) have enough permission to access your SP List. In addition, please check if the other users have owned a proper PowerApps licenses.

 

If you added the On-premises SQL Server table as data source in your custom form app, the end users must own PowerApps Plan 1 license at least to access your custom form app. Currently, the On-premises data connector is not available for Office 365 license includes PowerApps.

 

More details about licenses supported in PowerApps, please check the following article:

https://docs.microsoft.com/en-us/power-platform/admin/pricing-billing-skus

 

Best regards,

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

View solution in original post

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 (2,132)