Delegation - Handle More Than 2000 Items in Gallery | Handle 10000 Items from SharePoint List

[@akilabenjamin8268]

This is the only video I got all over the KZbin getting records as much as you can from sharepoint to Powerapps. You are a Super hero brohhh..........

[@infotechnest]

Thank you so much for the valuable feedback ❤

[@swornalatanayak5094]

Today I clear Delegation Thanks really helpful.

[@infotechnest]

Thank you so much ❤️

[@VictorDector]

You are truly a superhero.

[@infotechnest]

Thank you

[@snehabirajdar381]

Informative . Thanks for sharing

[@infotechnest]

Thanks Sneha...

[@kingquadri1850]

Awesome 👌

[@infotechnest]

Thank you so much

[@gbbarsing-u3f]

Hello and Thank you for the instructions this the best I have seen so far. I have two questions, 1> Why did you add a blank screen after adding ClearCollect? 2> Any downside of adding ClearCollect to the App's OnStart property?

[@infotechnest]

Hi I have added a blank screen to show you the function result in edit mode. It is not required in real life but here I have to show you by loading the formula and output the result in the edit mode. Based on the requirements you can use clearcollect on app onstart, it will not cause any issue.

[@singam3158]

Awesome video, Thank you very much. Your video helps me a lot.

[@infotechnest]

Thank you so much for the valuable feedback

[@RajeevKumar-hp7cv]

Thanks... really helpful...

[@infotechnest]

Thank you

[@linuxcosta7837]

Thank you so much!! Got the work done here!!!

[@infotechnest]

Thanks for the valuable feedback ❤

[@TheMKTube]

Thanks for the great video! Wont loading 10,000 records and storing them in a collection slow down the app? My list has 85 columns and I get a feeling there will be significant performance issues. Pls let me know if you have tested with data like that. Thanks!

[@infotechnest]

Hi, Use the collection function [Clearcollect(AllData,.....)] at App OnStart. It may help you to improve your app performance.

[@BAj3052]

thanks bro, but how to use this for sharepoint library more than 20000+ files?

[@DILOAyyarmalasahadevana]

I want to extend my sincere gratitude to Mr. Aniket Singh for their invaluable assistance and guidance in helping me resolve the issue. Their expertise and support made a significant difference and I truly appreciate as came on Teams call to fix my delegate issue.

[@infotechnest]

Thanks Dilo for your valuable feedback ❤️

[@sarathnaidu2725]

Will this work for SharePoint library please?

[@kamranpatel2998]

Hi aniket thanks for the video but how to overcome if the datasource is in Dataverse Or SQL etc

[@kavyanamani3756]

Thanks for your info. But what if we have dynamic sharepoint list i.e, if we dont know sharepoint records , then how we can create collection. Please answer

[@infotechnest]

The solution.is shared in this video is based on assumption of records.. eg you should have knowledge about the depth of your data set. Of course we don't built PowerApps applications for heavy datasets. For SharePoint list you should have approximations of dataset length and according to length you can create collections. Thank you

[@refugiotorres5547]

Hello..id tried to indexed the column call INDEX that i have in sharepoint like this video shows, but only the result gives INDEX and it is not showing the "Automatically created" part..and causes not give automatic number, i guess,the type of info in that column is Number but i dont have that result,How do you achieved that?...thank you by advance😅

[@vineetwadhwa5915]

Great Content!, Bdw I have a question in my mind that what if the user deletes and create a record in the list......in that case ID will decrease and increase i.e count......Will it give correct results or not?

[@infotechnest]

Heyy thanks for the feedback... If user deletes the record then item count reduce but again if user creates the record then id increase from the last item and count increases

[@vineetwadhwa5915]

@@infotechnest So it will work fine in all cases....No limitations in this approach... Right?

[@aniketsingh7413]

@@vineetwadhwa5915 yes

[@MrDionmar]

My list have more than 500k rows, witch workaround can I use to not facing performance issues ? Tks

[@infotechnest]

What is data source and where are you using

[@rohithirulkar4388]

Will this hamper page load time?

[@infotechnest]

No no it will not hamper page load time because all process will happens at app onstart

[@anshumanjha1441]

How did you create the item_id column which is taking value of ID column, please reply ASAP

[@infotechnest]

You have to create this column manually and try to make another flow to fill the item id using the flow for first time. And for the next make it auto increment.

[@snehabirajdar545]

Could you please show same by using Pagination with large data set

[@infotechnest]

Sure Thanks for your comment

[@anees.ahemad]

nice video, can you share this10000 record list ?

[@infotechnest]

Share your mail id please. Visit www.infotechnest.com to find contact details

[@BondaRamagopi]

Thanks for the valuable video, I have a SQL DataSource with 15k rows data. I wanted to load all the data to be displayed in canvas app screen, I used the same Filter and starts with function but not working for me. can you please provide your suggestions. Thanks

[@infotechnest]

Hi Thank you.. I have not tried with sql so far. Once i will get to know about this i will share with you

[@BondaRamagopi]

@@infotechnest Thank you

[@shaheenasayyad3549]

Hi @BondaRamagopi, have you resolved this issue..? if so please give me idea like how you did that

[@BondaRamagopi]

Hi @@shaheenasayyad3549 we used SQL Views to load the data into our PowerApps gallery without delegation issue.

[@shaheenasayyad3549]

@@BondaRamagopi Thankyou for your response. Can you brief about the process,is it ok to you connect through other source...?

[@fja5773]

Hi ! Good video. I think that this do not work with a excel connector with a TEXT Column.😢

[@infotechnest]

Hi Delegation function is different for different database. I will post with excel asap

[@paragkeshardas8139]

Bro I donot have any column call That Item ID ..How to do than In my application ANy item can be deleted so this index id we can not manage ....how to load data with out this?

[@infotechnest]

You can create a column by yourself

[@randika118]

Can we use this method for Dataverse as well?

[@infotechnest]

We can try this, I have not tried this with Dataverse. I will let you know once I use this approach with Dataverse

[@randika118]

@@infotechnest Thanks.😍

[@alokdwivedi7184]

I have azure sql datasource that is not having. Any columns that can be used for indexing how to do then?

[@infotechnest]

Please allow me some time to upload video with sql data

[@pavanpurushotham-m8m]

how to create indexed column automatically as i dont see ID column in primary column

[@infotechnest]

There is ID column by default in each list. It may be hidden. You have to create a column only then you have to implement formula to increase index by one each time, once item is created

[@mauleshshah1573]

Hi, Thanks for the video. How to add a numerical column in an existing SharePoint column? Thanks

[@infotechnest]

Hey you can create a column with integer type and make it auto increment type. Once a new item will be created that column value will be increased by 1.

[@GAURAVSINGH-cp4dx]

Hi, but collection limit is 2000 in PowerApps. Then how come you are getting more than 2000 records in collection?

[@infotechnest]

Please watch the video you will get the idea.

[@Jaraiya89]

I want to know if it will cause issues when you start a patch function or start adding drop-down menus etc

[@DILOAyyarmalasahadevana]

I have tried multiple te but still fails and error in code. Can you support sir.

[@infotechnest]

What error are you facing, Have you tried that I have explained in the video

[@DILOAyyarmalasahadevana]

@@infotechnest Yes I have tried. No error currently but data is not coming.

[@DILOAyyarmalasahadevana]

Even below 2000 is not showing now. Pls do support.

[@infotechnest]

Please share your email id or connect me through www.infotechnest.com

[@shubhamsatpathy6489]

Can I go beyond 10000

[@infotechnest]

Yes sure you can go beyond 10k

[@Negi_From_Pauri]

what if i want to see 5 million data? plz comment

[@infotechnest]

I have not used this type of large data set. When i will use then i will let you know.

[@shaikhnabi8276]

Where You Get 10,000 record List? Could You Please Suggest Me? 😅

[@infotechnest]

You can easily get on Internet.

[@shaikhnabi8276]

@@infotechnest ok...thank you For Quick Response..😊

[@salmankhan-eh8rg]

How to item-id column on existing data list

[@infotechnest]

Go to sharepoint list, create a column Item_id with data type number. Now you can choose your own method to add number in this column. One of the following method, you should approach if your list has larg number of data. Create an Instant Power automate and add number from 1 to number of total rows in Item_id column.

[@salmankhan-eh8rg]

@@infotechnest if you make video on this it's very helpful

[@infotechnest]

@@salmankhan-eh8rg sure i will make a video and will post here

[@salmankhan-eh8rg]

@@infotechnest please make video on how to create cloumn item id by help of instant power automate and how to add 1 to total numbres

[@smitchampak4427]

@@infotechnest have you created a video on how to use power automate to create increment id yet ?. it would be great help if you can share the link

[@munisekhard9193]

Please upload video in english

[@infotechnest]

Thank you, I will try to upload videos in English also asap

[@vamsikrishnamulakalapalli6789]

Pls upload video in English

[@infotechnest]

Sure Thank you