Hi all,
I have a dropdown called Competency (Lookup field points to another list). When the values are listing in dropdown I need to remove few choices alone. For e.g.. (Sales, Test, Corporates and few more). This should be removed rest everything should be displayed in the dropdown.
I gave this in items of dropdown but it is removing only the first value.
Filter(Choices(AssetTracker.Competency), Value <> And("Corporate Planning and Program Management" || "Sales"))
Any help/suggestion on this.
Thanks in advance.
Hi @Uthhra ,
Try
Filter(Choices(AssetTracker.Competency), Not(Value in ["Corporate Planning and Program Management", "Sales", "Test"]))
WarrenBelz
146,524
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,906
Most Valuable Professional