Two drop downs and choice columns - formula error

[cb23]

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!

[v-mengmli-msft]

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

[DJ_Jamba]

"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"

If(
   And(
      CountRows(DropdownPAims.SelectedItems) = 0,
      CountRows(DropdownSTasks.SelectedItems) = 0
   ),
   'My List',
   With(
   {var_SpList: 'My List'},
   Filter(
   	var_SpList, 
	And(
		DropdownPAims.Selected.Value in PrimaryAim.Value,
		DropdownSTasks.Selected.Value in SpecificTask.Value
	)
   )
)
)

[cb23]

Thanks but that brings up an error - there is something wrong with the DropdownPAims part I think. 

[cb23]

Nope, it's not changed it.  I don't see the placeholder either though, not sure if that's relevant? 

Is there a way to pull the image through another way? 

[cb23]

@DJ_Jamba just a quick update - I shared the app with my colleague and the images pulled through for him, but not for me! Strange...

[DJ_Jamba]

So it's single select (no idea why combo boxes entered my head 😂)
Try this instead:

If(
   And(
      IsBlank(DropdownPAims.Selected.Value), //Might be Selected.Aims
      IsBlank(DropdownSTasks.Selected.Value) //Might be Selected.Tasks
   ),
   'My List',
   With(
   {var_SpList: 'My List'},
   Filter(
   	var_SpList, 
	And(
		DropdownPAims.Selected.Value in PrimaryAim.Value,
		DropdownSTasks.Selected.Value in SpecificTask.Value
	)
   )
)
)

[cb23]

Hey, really appreciate your responses! Still not liking the formula though 😞 

 

[DJ_Jamba]

@cb23 

What exactly is in both drop downs? I thought they were single select drop downs linked to a SharePoint choice column.
Can you post the column settings in the list for PrimaryAim and SpecificTask?

E.g.

[cb23]

Ah... Yes, slightly different in that it is a choice column that allows multiple selections - screenshots attached.