Тёмный

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

Andrew Hess - MySPQuestions
Подписаться 8 тыс.
Просмотров 849
50% 1

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

Наука

Опубликовано:

 

21 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 26   
@andrewhess123
@andrewhess123 4 месяца назад
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
@hpkeong 4 месяца назад
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
@beecee9207 4 месяца назад
Thank you Andrew for sharing this! It's good to see things in a different perspective.
@andrewhess123
@andrewhess123 4 месяца назад
Thanks for watching beecee!
@adobestock7048
@adobestock7048 4 месяца назад
Very useful information, thanks
@andrewhess123
@andrewhess123 4 месяца назад
Thanks Adobe Stock! 😀
@patelbhargav
@patelbhargav 4 месяца назад
Thanks for sharing a different perspective on excel, it makes sense.
@andrewhess123
@andrewhess123 4 месяца назад
Thanks for watching Bhargav!
@majapamajapa9548
@majapamajapa9548 3 месяца назад
i have collected more than 1 lakh row.items of sharepoint list which works pretty well.
@brendana8069
@brendana8069 4 месяца назад
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
@andrewhess123 4 месяца назад
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
@andrewhess123 4 месяца назад
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.
@rudivanderlocht3212
@rudivanderlocht3212 4 месяца назад
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
@andrewhess123 4 месяца назад
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
@navarrocloud 4 месяца назад
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
@rudivanderlocht3212 4 месяца назад
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
@rudivanderlocht3212 4 месяца назад
and it only loads the next batch of 100 records if you scroll past the first 100.
@andrewhess123
@andrewhess123 4 месяца назад
Love the discussion all, thank you all for the input and advice for everyone!
@ethelinecimatu
@ethelinecimatu Месяц назад
It's very hard to hear you.
@andrewhess123
@andrewhess123 Месяц назад
Hi Etheline, not sure what could be wrong with this video. Is it too quiet?
@andrewhess123
@andrewhess123 Месяц назад
Or am I not speaking clearly? or background noise?
Далее
Wait! Solve Delegation Easily! In Power Apps Search
29:57
Разбудили Любимой Песней 😂
00:14
Dataverse Explained: Upscaling from Sharepoint
14:05
Power Apps Barcode Scanner For Inventory Records
8:06
Dynamic Repeating Combo boxes in Power Apps
26:12
Просмотров 2,4 тыс.
Explore Dataverse for Free With a Teams Environment
15:04
Creating an Edit Form and Fixing Defaults in Power Apps
25:51
Самый быстрый пылесос!
0:30
Просмотров 22 тыс.
iPhone, Galaxy или Pixel? 😎
0:16
Просмотров 555 тыс.