cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Langemyr
Advocate II
Advocate II

Licenses

Sad to say. Leaving the Powerapps platform since we are dependent on some sql data.

Price for 180 users became to lage.. $7200 /month for the sql connector.

Not well thought out by Microsoft.

They loose 130 E3 while we're at it

So if you ar at E3 license be carefull not to use a premium connector.

 

5 REPLIES 5
WarrenBelz
Super User
Super User

@Langemyr ,

Nothing wrong with synchronizing SQL with a SharePoint backend.

Can you explain in more detail what you mean?
Are you thinking of syncing a sharepoint list with sql and using sharepoint list for the app?

Hi @Langemyr ,

Yes - you could do that with Power Automate and one Premium Connector licence. There are also third party tools such as Layer2 that can do a job like this.

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Hi @WarrenBelz 

I have tried this but this takes a very long time to complete. Do you have another suggestion for flow that also deletes lines that have been deleted in sqlPowerautomateHvernatt.JPG

Hi @Langemyr ,

I was just giving you some concepts that I know others have implemented, although you would normally trigger the SharePoint on "When an item is created or modified" and do a nightly refresh back form the SQL. All this of course depends on how and when you use both data sets.

The deleting part would be problematic unless you simply updated from SharePoint as the item was modified and then completely refreshed the list daily. I have also heard the tool I mentioned does the job well.

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (1,753)