I am sorry i never explained my goal clearly. I have screenshots to collaborate my intend
I have two dropdowns for Tab 'ASSIGNED TO' ITEMS = Choices('IT Support Desk'.Department) and Priority = Choices('IT Support Desk'.Priority)
Another Tab, All Tickets and My Tickets, and My Ticket with Dropdown for Department and Title Search label.
I had multiple galleries for different tab display.
But I am now trying to use the same data table (if possible) and simply switch view depending on the Tab selected
This is my Item function for 'All Tickets' and 'My Ticket'
With the visible function as varTabSelected=1 || varTabSelected = 2
If(
varTabSelected = 1,
Filter(
'IT Support Desk',
Department.Value = Dropdown2.Selected.Value && StartsWith(
Title,
TextInput1.Text
)
),
Filter(
'IT Support Desk',
'Created By'.Email = User().Email
)
)
and Item for 'assigned to me' as
Filter(
'IT Support Desk',
'Assigned To'.Email = User().Email
)