Answered

Choice Delegation and Single Field Filter Omitting Multiple Values

(0) Share

Report

Posted on by Mer-Petti

I have the following code for the "Items" of my Gallery.

"Stage" is a choice field that has an optional value of Active, Planned, Hold, Backlog, Cancelled, Completed. I am unable to get around the Delegation issue here.

Additionally I am not able to see how to filter to Omit the two values that I do not wish to render in the Gallery.

CODE:

Filter ( 'Programs and Projects',
(StartsWith(Title,Search.Text)) &&
('IT Business Service'.Value = ITBS_DropDown.Selected.Value || ITBS_DropDown.Selected.Value = Blank())

&& Stage <> "Complete", Stage <> "Cancelled"))

Any guidance would be greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Sort by

Ashwin7104 671 on at

Like (0)

Report
Copy link

Link copied!

Hey @Mer-Petti ,

Please find responses from experts below:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Text-Does-not-Equal-Avoid-Delegation-in-SP/td-p/826278

https://powerusers.microsoft.com/t5/Building-Power-Apps/Delegation-Warning/td-p/533700

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,926 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Mer-Petti ,

You just need to include the four you want shown

Filter( 'Programs and Projects', ( Search.Text = Blank() || StartsWith( Title, Search.Text ) ) && ( 'IT Business Service'.Value = ITBS_DropDown.Selected.Value || ITBS_DropDown.Selected.Value = Blank() ) && ( Stage = "Active" || Stage = "Planned" || Stage = "Hold" || Stage = "Backlog" ) )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Mer-Petti 91 on at

Like (0)

Report
Copy link

Link copied!

WarrenBelz - This code doesn't work. But thanks for giving it a shot.

Was this reply helpful? Yes No
WarrenBelz 154,926 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Mer-Petti ,

What does not work? Assuming the values you posted are valid, it should do as you require.

Was this reply helpful? Yes No
Verified answer

zmorek 3,272 on at

Like (0)

Report
Copy link

Link copied!

If it's a Choice column you might need Stage.Value at the end of the "Stages" in the formula WarrenBelz provided you.

Was this reply helpful? Yes No