navigating to gallery filtered for the selected menu item

(0) Share

Report

Posted on by cs9331

I want to add the following if condition to my filter gallery item:

If(Gallery2.Selected.Section="All",
ticket,
Filter(ticket,Section = Gallery2.Selected.Section)
)

Here's my current filter gallery:

Search(
Filter(
ticket,
IsBlank(ComboBox1.SelectedItems.Value) || IsEmpty(ComboBox1.SelectedItems) || Status in ComboBox1.SelectedItems,
IsBlank(ComboBox1_1.SelectedItems.Value) || IsEmpty(ComboBox1_1.SelectedItems) || Section = ComboBox1_1.Selected.Value
),
TextInput1.Text,
"{Identifier}","FirstName","LastName","Status","Section"
)

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @cs9331 ,

Could you please tell me what the problem is with the code you're currently using? I hope you can describe it in as much detail as possible.

Rimmon

Was this reply helpful? Yes No
Cts1993 25 on at

Like (0)

Report
Copy link

Link copied!

I have an another screen (gallery2) that whenever the user select their section/department, they are navigating to their tickets only

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

Like (0)

Report
Copy link

Link copied!
Hi @cs9331 ,

Do you mean that only the user's own tickerts are displayed in gallery2?
You can use "User().FullName" to filter the items in the gallery2.
Add a column to the original data to store the user's full name, and then filter it.
Items of gallery2: Filter(AddColumns(ticket,"FullName",Concatenate(FirstName," ",LastName)),User().FullName=FullName)

Best regards,
Rimmon

Was this reply helpful? Yes No
Cts1993 25 on at

Like (0)

Report
Copy link

Link copied!

No. I want to combine the two above conditions

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

Like (0)

Report
Copy link

Link copied!

Hi @cs9331 ,

What are the two conditions? Filter and switch screens?

Was this reply helpful? Yes No
Cts1993 25 on at

Like (0)

Report
Copy link

Link copied!

Yes

Was this reply helpful? Yes No