cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GauravG
Responsive Resident
Responsive Resident

Filter working on single item not multiple selection

Hi All,

The items property of sub-audience field is set to 

Filter(Audience_List,Title=DataCardValue9.SelectedItems)

The issue is that even if my audience field has 3 fields selected, my sub-audience field filters values based on the last selected, in this case "Total Rewards"- and so not showing values corresponding to Benefits and D&I. Please suggest!

GauravG_0-1610826904348.png

 

19 REPLIES 19
RandyHayes
Super User III
Super User III

@GauravG 

Please consider changing your Formula to the following:

    Filter(Audience_List, Title in DataCardValue9.SelectedItems)

 

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!
GauravG
Responsive Resident
Responsive Resident

@RandyHayes It is still showing the values based on last selection made in audience field

GauravG_0-1610827858653.png

GauravG_1-1610827886017.png

 

RandyHayes
Super User III
Super User III

@GauravG 

What is the Items property of your combobox?

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!
GauravG
Responsive Resident
Responsive Resident

GauravG_0-1610830101007.png

The one you suggested!

RandyHayes
Super User III
Super User III

@GauravG 

Sorry, I meant the Audience combobox (I assume that is DataCardValue9)

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!
GauravG
Responsive Resident
Responsive Resident

Please find below!

GauravG_0-1610830527813.png

 

RandyHayes
Super User III
Super User III

@GauravG 

Try this for your formula on the sub-audience:

  Filter(Audience_List, Title in DataCardValue9.SelectedItems.Result)

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!
GauravG
Responsive Resident
Responsive Resident

@RandyHayes It still does not work and shows values in sub-audience based on last selection in audience. Some old solutions are referring using CONCAT- don't know how to use that.

Also, please note that "AUDIENCE_LIST" is a different SharePoint List that i am referring to for my values!

RandyHayes
Super User III
Super User III

@GauravG 

That will not make a difference and Concat will do you no good here.

 

So, what you have should be working.  So, I am actually wondering if your Audience combobox is actually having those items selected.

1) What is the DefaultSelectedItems property of the Audience combobox?

2) Place a label on the screen and set the Text property to : Concat(DataCardValue9.SelectedItems, Result & ";")

  See that the label actually shows all three items separated by a semi-colon.

 

I've got a few more, but let's start with those two.

 

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

PA Community Call

Power Apps Community Call

Next call is happening on April 21st at 8a PST.

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors
Users online (88,902)