Answered

Filter table with combobox of type choice - delegation warning

(0) Share

Report

Posted on by OleksPowerUser

Hello Community,

I'm quite new to PowerApp, and need you help after watching dozens of videos and articles, I still do not have solution.

I have SharePoint list 'Requests' where I have 'Status' column of type 'Choice' (single choose available in SharePoint). In my PowerApp I have tblRequests (table) and cmbStatus (combobox).

cmbStatus Items = Distinct(Requests,'Status '.Value) // ! delegation warning

cmbStatus OnChange= Set(varSelectedStatus,Concat(cmbSelectedStatus.SelectedItems,Value,", "))

So I'm trying to filter my tblRequests based on selected values in cmbStatus with following formula, but get delegation warning:

tblRequests Items = Filter(Requests,StartsWith('Status '.Value,varSelectedStatus)) // ! delegation warning

I would really appreciate you help!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

WarrenBelz 155,922 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @OleksPowerUser ,

Your issue stems mainly from your use of a Choice column for Status. If it was a Single Line of Text and you put your choices in the Power Apps combo box Items, the second one would work fine (StartsWith on complex field types such as Choice is not Delegable). Distinct() however is a different matter, however if your list is large, there is a workaround of sorts in this blog of mine.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @OleksPowerUser ,
Can you try this -
Filter(Requests, Status.Value in Split(varSelectedStatus, ", "))

Was this reply helpful? Yes No
OleksPowerUser 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @Anonymous but it still returns delegation warning, as 'in' function is not delegable for SharePoint

Was this reply helpful? Yes No
OleksPowerUser 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, @WarrenBelz, unfortunately, the approach from your article (which I found really nice) still do not want to work with choice type, when I debugging (set delegation limit to 1 item in the settings) it returns me 1 item in combobox. Btw do you know if any workarounds for filtering table with complex field types such as Choice?

Thank you!

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,922 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@OleksPowerUser ,

I could say do not use them (I do not), but that probably does not help you. This is Delegable

Filter( Requests, 'Status '.Value = varSelectedStatus )

or if Status was a Text field, so is this

Filter( Requests, StartsWith( 'Status ', varSelectedStatus ) )

Distinct() simply is not Delegable, however the workaround I posted may be a possible solution.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No