cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Liuk87mi
Regular Visitor

Powerapps - filter combobox with unselected values ​​from another combobox

 

Hello,
I have a need of this type:
I have 2 comboboxes both populated by "activity list" (5 activities)

I would like that, if from the first multiple-selection Combobox, I select only 3 activities,

the 2 unselected activities are listed in the second combobox.

obviously using a formula of this type does not work

Filter (listactivities, activities <> Combobox.selecteditems.Attivities)

does not work because I am doing a check between a text and a tablese instead I use

 

Filter (listactivities, activities <> Combobox.selected. activities)

I only filter the last of the three selected activities or tried with ForAll to make it check the condition for each selected item but I didn't arrive at a function worthy of the name.

Thank you

 

1 ACCEPTED SOLUTION

Accepted Solutions
RandyHayes
Super User
Super User

@Liuk87mi 

Please consider changing your Formula to the following:

Filter(listactivities, 
    !(activities in Combobox.selecteditems.Attivities)
)

 

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

View solution in original post

2 REPLIES 2
RandyHayes
Super User
Super User

@Liuk87mi 

Please consider changing your Formula to the following:

Filter(listactivities, 
    !(activities in Combobox.selecteditems.Attivities)
)

 

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!
Liuk87mi
Regular Visitor

Thank You!

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,258)