Notifications
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 796 Most Valuable Professional
Michael E. Gernaey 327 Super User 2025 Season 2
Power Platform 1919 268
