Choosing your Data Source in Power Apps - SQL, Dataverse, SharePoint, Excel, Dataverse for Teams
Vložit
- čas přidán 25. 07. 2024
- Do you only use one data source and stick with in Power Apps with out actually thinking of different data sources that you could use for your Project? This is the first question we should be asking our selves. Which data source is right for our project?
Is it SQL?
Is it Dataverse?
Is it SharePoint?
Is it Excel?
Is it Dataverse for Teams?
Why not?
Choosing the right data source in Power Apps is crucial for the performance, scalability, and maintainability of your application. It's important to consider the nature of your data, whether it's static or dynamic, and the volume of data you'll be dealing with, as this can significantly impact your app's responsiveness and speed. Compatibility with Power Apps is another critical factor; ensure the data source you select can be easily integrated and supports the functionalities you need. Security and compliance requirements should also guide your choice, especially if you're handling sensitive information or operating in a regulated industry. Finally, consider the cost implications and scalability options of the data source, as these will affect the long-term viability and expansion capabilities of your Power Apps solution
Chapters:
0:00 Introduction
0:55 5 Most Common Datasources in Power Apps
2:00 Power Apps if for the Citizen Developer
3:25 Why would you want to use SharePoint?
7:14 Proof Power Apps is not Forever
8:00 How long an app should last by Data source
9:30 Why would you use Dataverse for Teams?
11:20 Why Dataverse?
12:34 Why SQL?
14:20 Criteria to think about when choosing a Data Source
15:05 Conclusion - Věda a technologie
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!
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
Thank you Andrew for sharing this! It's good to see things in a different perspective.
Thanks for watching beecee!
Very useful information, thanks
Thanks Adobe Stock! 😀
Thanks for sharing a different perspective on excel, it makes sense.
Thanks for watching Bhargav!
i have collected more than 1 lakh row.items of sharepoint list which works pretty well.
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?
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.
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.
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. 🙂
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!
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.
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
and it only loads the next batch of 100 records if you scroll past the first 100.
Love the discussion all, thank you all for the input and advice for everyone!
It's very hard to hear you.
Hi Etheline, not sure what could be wrong with this video. Is it too quiet?
Or am I not speaking clearly? or background noise?