Unanswered

Filtering Choice functions

(0) Share

Report

Posted on by jv123

224

I am trying to filter a choice function and I saw a statement in the community that an "in" operator is needed but I see no examples. Can someone point me in the right direction or provide some insight on syntax?

Choices(Details.Parts)

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

cha_cha 4,932 Moderator on at

Like (0)

Report
Hello @jv123

Not yet sure what you are filtering but a normal Filter function can also do the function.

This will filter the choice and exclude a box
Filter(Choices(Details.Parts), !(Value = "Box"))

As for the in function, please look at this website resource, it has all the examples and detailed explanations to get you started.
https://zeitgeistcode.com/powerapps-in-operator/

✔️
Just in case my response helped you solve your problem, please mark/accept this as a SOLUTION. This helps community members if they experience a similar issue in the future.

🔗
🕸bistek.space 🐦 @cha_bistek 📺 @BisTekSpace

Was this reply helpful? Yes No
jv123 224 on at

Like (0)

Report

Thank you. The end goal is to filter based on the results of a selected drop-down. So essentially something like If(dropdown4.selected = "Selection in text") then filter the choices....

Was this reply helpful? Yes No
cha_cha 4,932 Moderator on at

Like (0)

Report

You Choices' Items would be

Filter( __YourDataSource__,
If(Dropdown4.Selected="ChoiceA",FirstFilter_Condition, true),
If(Dropdown4.Selected="ChoiceB",2ndFilter_Condition, true)
)

Adding the true in the if tells the app that it will return all results.

Was this reply helpful? Yes No
jv123 224 on at

Like (0)

Report

The choices are to display a list of choices available in combobox that essentially retrieves values generated by a lookup column.

Was this reply helpful? Yes No
jv123 224 on at

Like (0)

Report

I'm not sure I understand the FirstFilter_Condition and 2ndFilter_Condition part of your equation.
Do you mean something like this?

Filter(Choices(Details.Parts),
If(Dropdown4.Selected.Result ="Proj", Filter(Period, = CorrespondingMonth =Text(Month(Now())), true))

If that is the case it's not working

Was this reply helpful? Yes No
Rusk 1,369 Super User 2024 Season 1 on at

Like (0)

Report
Hi @jv123 ,

If you just want to filter by a dropdown, try:
Filter('Your Data Source',ID = Dropdown2.Selected.ID)

In this example, the Items for my dropdown are:
ShowColumns('Your Data Source',"ID")

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @jv123,

I think you want to filter a LookUp column choices based on a column from another list where your LookUp column retrieves values from, right?

If so, please share more details about your scenario, like how you set the Items property of your dropdown control?

I think there are two lists, List 1 has a column that you used to populate a dropdown control and another Text column to provides values for LookUp column in List2.

So that you could try the following formula:

Filter(Choices(Choices(Details.Parts),Value in Filter(AnotherList,Column1=dropdown4.selected.Column1).TextColumn)

Note that the Column1 is the text column you populate the dropdown4 with and the TextColumn is the column that your LookUp column retrieves values from.

Was this reply helpful? Yes No
jv123 224 on at

Like (0)

Report

I'm sorry v-qiaqi-msft but this didn't work.

Was this reply helpful? Yes No