You’re offline. This is a read only version of the page.
153
I have created an app that reads a barcode (primary key of SQL table) and then lookups the part name and post this form entry to a SharePoint table.. My query is because of the SQL connector for On-Premise Gateway each user needs to have PowerApps Premium to use the app is my understanding.
Are there any other suggestions of moving this data table to another location to avoid this need for the Premium connector access for each user? Would Dataverse be any benefit..
Thanks
Actually that's little compared to what it can do, up to 30 million, plus do you need to move ALL the data or just certain columns?
SharePoint limits - Service Descriptions | Microsoft Learn
That, I believe is your best option for getting rid of the license fee.
If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others
Cheers
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
Depending on the size of the data, can you move it to a SharePoint Online list and avoid the license cost? Or at least keep a copy in SharePoint online. Yes you would need a way to sync them from SQL to SharePoint, unless you only do it once, but hey hehe I don't have all the answers.
If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others
Cheers
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
#1
stampcoin
17
#2
ankit_singhal
11
Super User 2025 Season 1
#3
mmbr1606
9
Super User 2025 Season 1
Share
Report
All responses (
Answers (
