Filter gallery by dropdown

[JimboSey]

Hi, 

I currently have a full functioning App, which basically uses a form to log maintenance items, and then shows them in a Gallery, I have applied several filters on the Gallery, but now I need to update the functionality slightly. 

This is the code I have now on the Gallery 

Filter(

Filter(MaintRequests,

(Status.Value = Status_Radio_1.Selected.Value

||

Status_Radio_1.Selected.Value = Blank())

&&

((Checkbox_Me_1.Value && Owner.Email = User().Email)

||

Checkbox_Me_1.Value = false && Checkbox_Other_1.Value = false)

||

(Checkbox_Other_1.Value && Owner.Email = Resource_ComboBox_1.Selected.Email))

,

TextBox_1.Text in Title & Code)

This all works fine, but what I want to add now, is a combobox on the main screen of my App (from a choice column in SP) which filters the gallery based on that dropdown selected. 

Lets say the new combobox will be called projectnamedropdown.

End result I'd like is the gallery to filter accordingly from the projectnamedropdown selected.

Thanks 
J

[CNT]

@JimboSey You have to add one more condition to your Filter which will look like (change column, control name as needed),

projectname.Value = projectnamedropdown.Selected.Value

Please remember to give a 👍 and accept my solution as it will help others in the future.

[JimboSey]

Thanks for your speedy reply, 

I am quite a novice, so the code I quote above was a from a video I followed. So not entirely sure how/where to add the additional filter condition to my code. 

Thanks

[CNT · Accepted solution]

@JimboSey You will add it to your inner Filter like this,

Filter(
	Filter(MaintRequests,
		(Status.Value = Status_Radio_1.Selected.Value
		||
		Status_Radio_1.Selected.Value = Blank())
		&&
		((Checkbox_Me_1.Value && Owner.Email = User().Email)
		||
		Checkbox_Me_1.Value = false && Checkbox_Other_1.Value = false)
		||
		(Checkbox_Other_1.Value && Owner.Email = Resource_ComboBox_1.Selected.Email)
		&&
		projectname.Value = projectnamedropdown.Selected.Value
	)
	,
TextBox_1.Text in Title & Code)

Please remember to give a 👍 and accept my solution as it will help others in the future.

[JimboSey]

Brilliant, I had to tweak the code slightly (see below) but it now works a treat, thanks so much

Filter(
	Filter(MaintRequests,
    LearningFormat.Value = projectnamedropdown.Selected.Value,
		(Status.Value = Status_Radio_1.Selected.Value
		||
		Status_Radio_1.Selected.Value = Blank())
		&&
		((Checkbox_Me_1.Value && Owner.Email = User().Email)
		||
		Checkbox_Me_1.Value = false && Checkbox_Other_1.Value = false)
		||
		(Checkbox_Other_1.Value && Owner.Email = Resource_ComboBox_1.Selected.Email)
		
		
	)
	,
TextBox_1.Text in Title & Code)

[CNT]

@JimboSey 

Glad to help!

Please remember to give a 👍 and accept my solution as it will help others in the future.