Help with Delegation warning

(0) Share

Report

Posted on by Anonymous_Hippo

1,247 Super User 2024 Season 1

Hello All !

I have a single-line text column called project tradename that I would like to filter (DB is Sharepoint). I am using a multi-select and searchable combobox. Since X amount of projects can be added , how can i get around this delegation issue

Filter('Project Tracker', (Len(TabViewProjectStatus.Selected.Value) = 0 || 'Project Status'.Value in TabViewProjectStatus.SelectedItems.Value))

Screenshot 2022-09-02 160143.png

Delegation warning on "In" and "||" functions

All ideas are welcome !

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

jatcube 508 on at

Like (0)

Report

@Anonymous_Hippo the problem is the 'in'. try 'StartsWith' maybe?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous_Hippo

Are you going to have more than 2k projects? If not, you can ignore it.

Was this reply helpful? Yes No
Anonymous_Hippo 1,247 Super User 2024 Season 1 on at

Like (0)

Report

@Drrickryp Yes !! I am going to have more than 2k projects . Could you please provide some suggestions 🙂

Was this reply helpful? Yes No
Anonymous_Hippo 1,247 Super User 2024 Season 1 on at

Like (0)

Report
Hello @jatcube !

This is a good idea ! While "In" cannot be directly replaced by startswith - we can get it to work but unfortunately only one option can be selected. I do not think there is a way to keep multiselect on and use startswith

The below is one example i found in the community, but like you can see here we can use only one option

Filter(Choices(YourTable.ChoiceColumn),StartsWith(Text(Value),"2"))

In my scenario i have a single line text column which i need to filter

Thanks

Was this reply helpful? Yes No
Verified answer

Akser 1,546 Moderator on at

Like (1)

Report

Not the best solution but putting it out there as a last resort. Like many do, store your projects in memory OnStart.

Concurrent(
ClearCollect(TempCollection1, Filter(Projects, ProjectId > 0, Project Id < 2000)),
ClearCollect(TempCollection2, Filter(Projects, ProjectId > 2000, Project Id < 4000)),
ClearCollect(TempCollection3, Filter(Projects, ProjectId > 4000, Project Id < 6000))
);

ClearCollect(FinalCollection, TempCollection1, TempCollection2, TempCollection3);

Clear(TempCollection1); Clear(TempCollection2); Clear(TempCollection3);

Was this reply helpful? Yes No
Anonymous_Hippo 1,247 Super User 2024 Season 1 on at

Like (0)

Report

Thank you @Akser ! Unfortunately this looks like the only possible solution other than using delegable DBs like dataverse or SQL server 🙂

Was this reply helpful? Yes No
mikedem 6 on at

Like (0)

Report

Workable, except you are excluding item 2000, 4000, and 6000

Was this reply helpful? Yes No