Delegation warning

(0) Share

Report

Posted on by common_user

211

Hi all,

I have a problem with delegation.

I have a table in SharePoint with 3 columns and 3000 rows. I would like to create a comboBox and two textImput, so when I select a value in the comboBox i want to autofill in the other two textInput. I have unique value in the textInput when I select a value in a comboBox.

My problem is about 3000 rows and delegation in the comboBox.

Is there a workaround?

Thanks all

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Drrickryp Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!

@common_user

Will your list ever exceed 4k?

If not, (from @WarrenBelz 's blog Practical PowerApps:

With( { wAsc, Sort( MyList, ID ), wDesc, Sort( MyList, ID, Descending ) }, ClearCollect( colMyCollection, wAsc, Filter( wDesc, !(ID in wAsc.ID) ) ) )

Was this reply helpful? Yes No
BCLS776 8,994 Moderator on at

Like (1)

Report
Copy link

Link copied!

One key way to work with delegation is to carefully pre-filter the Items property of your combobox so that it never has to sort through as many as 2000 records. I don't know much about your app, so I'll give an example:

Let's say I have a list of 3000 records, and those records contain a text field called "Location". If my combobox only needs to contain records from a particular location, I can use a Filter() to reduce the row count in the Items property to get below 2000. E.g. Filter(myList, Location = "Paris")

Would something like that work in your situation?

Was this reply helpful? Yes No
common_user 211 on at

Like (0)

Report
Copy link

Link copied!

Hi @Drrickryp,
where can I find the post of @WarrenBelz ? I'm trying to use this formula.
@BCLS776 thank you, I try to change my DB but in my question I can't use your suggest because I have 3K unique value to use in comboBox

Was this reply helpful? Yes No
common_user 211 on at

Like (0)

Report
Copy link

Link copied!

@Drrickryp
I find the post
https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/With-Statement-to-include-non-Delegable-filters/ba-p/660997

I try to do this.
Thank you

Was this reply helpful? Yes No
common_user 211 on at

Like (0)

Report
Copy link

Link copied!

@BCLS776 @Drrickryp , just a question, do you know if is it possible to create a comboBox that contain all value from two different list in sharepoint?
For example, I have:
List1:
-A
-B
-C

List2:
-D
-E
-F

Is it possible create a combobox with all value? (A,B,C,D,E,F)

Thank you

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@common_user

https://www.practicalpowerapps.com/delegation/with-statement-managing-delegation/

Collect(cList1,List1); Collect(cList2,List2); Collectl(cList3,cList1,cList2)

Was this reply helpful? Yes No