Choosing your Data Source in Power Apps - SQL, Dataverse, SharePoint, Excel, Dataverse for Teams

[@andrewhess123]

I'm inviting you to share your ideas about why you use certain data sources! All recommendations are welcome, even telling me I'm wrong is welcome! Let's share our ideas together for the community!

[@hpkeong]

Hi Andrew, Hong here. Good explanation. In fact I used CDM and now Dataverse on 2016 when PowerApps released for trial, we are lucky to have MS managers to help within 2016 to develop autocreation of Custom Connector software and connected to our own DB based on MongoDB and stored inside AWS. So we have been using 99% of Custom Connector since early 2017 for all our customer MRP with millions of data. MongoDB structure allows us to avoid all barrier and we have no delegation issues (non existence). All Custom Connector are automatically created. Just sharing.... Tq

[@beecee9207]

Thank you Andrew for sharing this! It's good to see things in a different perspective.

[@andrewhess123]

Thanks for watching beecee!

[@adobestock7048]

Very useful information, thanks

[@andrewhess123]

Thanks Adobe Stock! 😀

[@chairattangthong]

well explanation. Thank you

[@andrewhess123]

Thank you! Chairat

[@chairattangthong]

@@andrewhess123 ❤️

[@brendana8069]

Thanks for summarizing how SQL differs from the alternatives. Would you be able to create a guide for using SQL and PowerApps for accessing secure on-premise data?

[@andrewhess123]

OOooo that's a difficult one, because then I would need my own on prem server but I may be able to set that one up. Let me think about that, but I do think that's huge.

[@andrewhess123]

As soon as this new Microcenter (pc store) is built near me, I'm going to buy everything for a server. And that may be on the list.

[@majapamajapa9548]

i have collected more than 1 lakh row.items of sharepoint list which works pretty well.

[@patelbhargav]

Thanks for sharing a different perspective on excel, it makes sense.

[@andrewhess123]

Thanks for watching Bhargav!

[@chairattangthong]

Dear Andrew, Power apps for SQL as Datasource need to pay a premium connector license / month ? I am not sure about that. it will cost as dataverse ?

[@andrewhess123]

Yes Power Apps with SQL requires premium, just like Dataverse.

[@chairattangthong]

@@andrewhess123 Thank you so much for your information and support

[@rudivanderlocht3212]

We have PowerApps with SharePoint lists as our data source, which includes over 20,000 records. We haven’t encountered any performance issues. The key lies in developing your app the right way! The notion that there’s a 5,000-item limit is a common misconception among developers. 🙂

[@andrewhess123]

My assumption is you're just writing to SharePoint from your Power App, and not as much editing that 20,000th record. Which is totally fine, I do the same!

[@navarrocloud]

The issue here is the list view, which means that the View used to display the list items in SharePoint has that 5k limit. I have worked with Lists that have over 100k items without any issues following delegation techniques and using Power Automate Flows to fetch the data to my Power Apps.

[@rudivanderlocht3212]

Delegation is key... but apart from that a Powerapps gallery only loads 100 items at a time, and then you select your item to edit... so the number of items in your data source is "not really" important as the heavy lifting is done by MS on their servers. .. and they can handle let's say 100.000 items without any issue. @@andrewhess123

[@rudivanderlocht3212]

and it only loads the next batch of 100 records if you scroll past the first 100.

[@andrewhess123]

Love the discussion all, thank you all for the input and advice for everyone!

[@ethelinecimatu]

It's very hard to hear you.

[@andrewhess123]

Hi Etheline, not sure what could be wrong with this video. Is it too quiet?

[@andrewhess123]

Or am I not speaking clearly? or background noise?