how to have drop down selected with single line and filter gallery with two dropdown selection??

(0) Share

Report

Posted on by bbsin

1,994

i have a SP list that is picking the user email when they lock in

I want to create a dropdown for user to select their own email and filter the gallery. may I know how to do it?

the Search category - Choices(list.Category) - as ComboBox 1

filter of gallery is SortByColumns(Filter(list)',IsBlank(ComboBox1.Selected.Value)||IsEmpty(ComboBox1.Selected.Value)||Category.Value=ComboBox1.Selected.Value),"ID",Descending)

which is working fine , but now I want to add second filter box of user. how to make the two work together?? Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @bbsin ,

Since the Requestby column is a text type column, I assume your search by user combo box would be populated with a Distinct results:

Distinct(list,Requestby).Result

then the Gallery filter formula would be:

SortByColumns( Filter( list', (IsBlank(ComboBox1.Selected.Value) || IsEmpty(ComboBox1.Selected.Value) || ActivityChoices.Value = ComboBox1.Selected.Value) && (IsBlank(ComboBox2.Selected.Result) || IsEmpty(ComboBox2.Selected.Result) || 'email address' = ComboBox2.Selected.Result) ), "ID", Descending )

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
bbsin 1,994 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-jefferni

yes I missed it.. Thx will try it

Ok

Was this reply helpful? Yes No
bbsin 1,994 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-jefferni can I ask u a issue ? not related to this?

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@bbsin ,

One thread one topic, this would helps other users in the community quickly find the questions and solutions they need.

So, you'd better post new threads if you have other questions.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
bbsin 1,994 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-jefferni

Yes it's working . thank you so much 🙂

Was this reply helpful? Yes No
bbsin 1,994 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-jefferni

Hi Jefferni,

can you advise for some reason it's not working I not sure why?

thanks

Was this reply helpful? Yes No