I am in the process of convincing my boss why we need to use an RDBS for our company data (which is currently stored as Sharepoint lists). This is exactly what I was looking for. Thanks!!
Buddy the explanation is very detailed as always. The good thing is all the points are known to me but never felt bored through 15 min of the video. Great job! I am 10000% sure it should be a base video for every developer before they propose SharePoint as DataSource.
Another great video! I would also add point #8 - SharePoint is a standard connector, thus does not require premium license to run the app. From my experience, it is possible to make pretty decent low cost apps using SP as a data source if you know how to tackle it's limitations.
Thanks for your great video(s)! It's not easy to keep all this facts in mind and also handle all the changes that are comming. (Microsoft Lists, SharePoint 2010 Workflow retirement).
The world of Microsoft 365 is an ever changing landscape. New features are added at a rapid pace. Keeping up with the pace is a full time job in itself :)
Thank You. Hopefully, with time as more and more people watch my content they will subscribe. The thing about me is I don't go about asking for people to subscribe. I know if I do I would probably get more but I don't think that looks good. My subscribers have re-shared by content within their networks and helped me grow to this point and I hope they keep doing the same.
Thanks for the wonderful feedback. The reason I did this video is because I have seen a lot of Power Apps projects related to SharePoint run into challenges because these points were not taken into consideration.
Hi Reza, great video!!! You're one of the best generating content for Power Apps because you focus on design too. What about working with a list of more than 1 millon items, how it works? Delegation is limited for 5k records or you can use even if your list has 30 million items?
Delegation Playlist - ru-vid.com/group/PLTyFh-qDKAiE6ia-D94Qk5-AzpN4dqOmD Delegation works for large data sets (30 million for SP List). Key is to ensure you index your SP columns (due to 5k limit of SP) and use delegation in Power Apps.
Hi .. have a relate question if I might… most or all the limitations you highlight refer to the size of the data… but are there any limitations/ concerns in terms of user base (and related concurrent access to the data for example) if using SharePoint as the data source? In my use case data size is not an issue, but we are planning to grow from ~50 app users to ~1000…. Not sure about concurrent users, but I am sure it will be greatly increased… maybe 50-100 concurrent users in the app at some point?… Would that be a problem on the SharePoint backend? Is there any known limit or information available? Thanks in advance. Great channel btw!
Great information, this is why I am getting error while creating credit concession sharepoint form in power app.. But I don't know how to get rid of it as I can't delete any column as all the columns are needed to perform flow
Unfortunately, there is no way around it. SharePoint has limitations and it is good for simple scenarios. Selecting the right data source upfront is key.
Thanks for great videos! So if we use CDS will it directly solve those 7 issues? I am learning powerapps and still deciding which datasource will work the best for my needs
CDS has been renamed to "Dataverse" :) Dataverse is a relational database and has most of its bases covered. Dataverse does come with licensing costs - premium licensing & also has costs based on capacity (size of the database)
Yes excel can be used. But excel has plenty of limitations one of them is delegation. Cannot work with excel data more than 2k records. SharePoint, Dataverse (CDS) or SQL are best choices.
@@RezaDorrani Hi Reza I did all the steps with the multiple upload with power automate but get an error on the button Invalid number of arguments received ContractsManagementFlow.Run(JSON(ColContracts,JSONFormat.IncludeBinaryData)) please assist me
Hi, very useful video. I want to know,is there also a limitation on using the search function for large lists. Though i have changed the rows count to 2000 in advance setting, it is still giving an error. Please help in the scenario..
Hi Ishita, Search is not a delegable function with SharePoint. Hence you will always run into the delegation warning in this case. Try replacing it with StartsWith function. One cannot perform contains query with sharepoint
Hi Reza. Great content as always. I have a question regarding filtering a list in relation to the 5000 treshold limit. In this video you added indexes on date and choice columns to be able to filter the gallery. I need to filter my gallery on a people column, like SPPeopleColumn = PowerAppsCurrentUser and the request if fully delegable. If i add an index to SPPeopleColumn , is it going to work or the list view treshold error will be thrown because of the people column type ? Thank you for your answer.
You absolutely can modify a single column in SharePoint from Power Apps. You can do the single column modification option using Patch function Check - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-g9ChYuTdNd4.html The 7 key points video only talks about the key points you need to consider when working with large SharePoint lists and Power Apps.
Giboin Florent I have come across plenty of customers who have built some extremely complex structures that have exceeded these limits. But I do agree in most cases one would not exceed.
Reza Dorrani good job opportunity for you :-) I usually say, if a table as too much columns to be displayed on one screen, change your data model. I know it’s extreme but it’s also a good starting point to avoid trash tables.
Giboin Florent Agreed. This week I came across a scenario where the user had a list with 140+ columns :) My solution was to get back to the drawing board.
Hello Reza, Thanks for sharing! I have a list that contains around 13k+ items, and another list that contains a lookup column to get information from the ID of the first list. The issue I am facing is that in Power Apps, the following lookup column Choices([@Opportunities].CompanyID) throw a threshold error saying that "The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator." Knowing that I have created indexed columns for this column, and filtered by status value. Any suggestions on how to solve this issue for the lookup ID column?
Have you indexed Opportunities column? Is ColumnID an additional column that you have selected as part of the lookup? Also, why do you want to get the data using Choices column when you can directly query the source list and get the info.
Hi Amit, You cannot directly connect to a folder but you can connect to the document library. Then if you need to show files in a specific folder then apply filtering as follows Filter(Documents,'Folder path'="Shared Documents/ABC/") In my case ABC is the name of the folder.
@@RezaDorrani Ahh wierd, it means I cannot connect to the data of the placed file, I can only play with the metadata of file placed at document library say filenamee, modified by, created by etc.
Power BI - Amit Srivstava when you say connect? Do you mean editing? You can read,edit & delete the metadata from Power Apps. Full CRUD operations are supported.
@@RezaDorrani I mean, I have a excel file (contains country, city detail of employee) ,that is placed at SharePoint folder, now I want to create a Power App which connect to this excel data and user can edit/add country, city detail to the excel file directly from power app.
Hi Sundra, There have been some new actions added to flow recently which will make your use case easier. To create a folder there is an action called "Create new folder" Break permissions - "stop sharing an item or a file" Grant permissions - "grant access to an item or a folder"
SharePoint list can hold upto 30 million records. You would have to take into account delegation in Power Apps. Hope you have seen my delegation playlist series.
@@RezaDorrani Yes of course I have seen I done indexing , sorting. I need to understand how to create and mange views. Every 10 days it exceeds threshold , driving me bananas 🍌 and freezing the app😱
