The items property of sub-audience field is set to
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!
Please consider changing your Formula to the following:
Filter(Audience_List, Title in DataCardValue9.SelectedItems)
I hope this is helpful for you.
What is the Items property of your combobox?
Sorry, I meant the Audience combobox (I assume that is DataCardValue9)
Try this for your formula on the sub-audience:
Filter(Audience_List, Title in DataCardValue9.SelectedItems.Result)
@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!
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.
Check out new user group experience and if you are a leader please create your group
Next call is happening on April 21st at 8a PST.
May the fourth be with you, join us online!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.