Two drop downs and choice columns - formula error

(0) Share

Report

Posted on by cb23

326

Hi there,

I am building an app to filter people based on the skills they offer and the user's primary aim. I have two drop downs (named DropdownSTasks and DropdownSTasks) which are linked to a list and I want the gallery to display the relevant items based on the two drop down selections. The choice columns have multiple values in them (because the people have multiple skills) and this isn't something that I can change.

At the moment, dropdown 1 has the following in the Items property: Choices('MyList'.'PrimaryAim') and dropdown 2 has

Choices('MyList'.'SpecificTask').

For the gallery, I have the following:

Filter('My List', PrimaryAim = DropdownPAims.Selected && SpecificTask = DropdownSTasks.Selected)

However, DropdownPAims is green and DropdownSTasks is red in the formula bar. Can anyone help so that I can display the correct results?

As a separate issue, I would like all people to display before a user selects an option from the dropdown. How would I achieve this?

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (18)

Answers (0)

DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (0)

Report
Hi @cb23

This will result in a record:
DropdownPAims.Selected
(same for the other dropdown)

Your gallery Filter expression requires a single value, so if you put a dot after the reference for each drop down, it should give you something to select (usually it's value) e.g.

Filter('My List', PrimaryAim = DropdownPAims.Selected.Value && SpecificTask = DropdownSTasks.Selected.Value)

Note: I'm providing Value as an example, it could be something else like Aims or Tasks

Was this reply helpful? Yes No
v-mengmli-msft on at

Like (2)

Report
Hi @cb23 ,

Do you mean that PrimaryAim and SpecificTask are multiple choices columns?

If so, please try this.

Filter('My List', DropdownPAims.Selected.Value in PrimaryAim.Value && DropdownSTasks.Selected.Value in SpecificTask.Value)

Best regards,

Rimmon

Was this reply helpful? Yes No
cb23 326 on at

Like (0)

Report

Hi @v-mengmli-msft

Thank you that is working better now and is pulling the correct people across but there is still a delegation warning (below). Any ideas what to change for this?

Was this reply helpful? Yes No
DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (1)

Report
Depending on size and complexity of your SP List, try this first (we can add a basic filter to the With statement if it still complains):
With( {var_SpList: 'My List'}, Filter( var_SpList, And( DropdownPAims.Selected.Value in PrimaryAim.Value, DropdownSTasks.Selected.Value in SpecificTask.Value ) ) )

Was this reply helpful? Yes No
cb23 326 on at

Like (0)

Report

Thank you! That seems to be working!

The only thing that isn't pulling through for me is the picture for the people selected. I have it set to
ThisItem.Person.Picture but it is just blank. Any ideas?

Was this reply helpful? Yes No
cb23 326 on at

Like (0)

Report

Also, if I wanted to display all people in the gallery when someone first comes to the app, what would I need to do? Put something in the Default property? Thanks again 🙂

Was this reply helpful? Yes No
DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (0)

Report

Are you pulling from a Person column in your SP list?

Was this reply helpful? Yes No
cb23 326 on at

Like (0)

Report

Yes

Was this reply helpful? Yes No
DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (0)

Report

Sometimes Power Apps is a bit weird with images from SharePoint.
If you save and close your app, then load your SharePoint site in one tab, then bring up the app in another tab, do the pictures display now?

Was this reply helpful? Yes No
v-mengmli-msft on at

Like (1)

Report

Hi @cb23 ,

Everything works fine in my tests, the problem may be caused by a sync issue, it seems that only when the user accesses SharePoint, his photos are synced from Office365 to SharePoint.

Best regards,

Rimmon

Was this reply helpful? Yes No