Announcements
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
@craig_01
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 othersCheersThank YouMichael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsofthttps://gernaeysoftware.comLinkedIn: https://www.linkedin.com/in/michaelgernaey
@FLMike Thanks for the input, i reckon there is probably to much data to import into Sharepoint List. Probably 15,000 rows.
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 392
WarrenBelz 364 Most Valuable Professional
Kalathiya 271 Super User 2026 Season 1
