web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps HELP with Data Table

Power Apps

Unanswered

HELP with Data Table

(0) Share

Report

Report

Posted on by eddysonkh

51

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
)

Annotation 2023-01-11 080058_LI.jpg

Annotation 2023-01-11 080109.png

Annotation 2023-01-11 082039.png

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

BCBuizer 22,833 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @eddysonkh ,

I think the below should help you in the right direction:

Filter( 'IT Support Desk', If( varTabSelected = 1, Department.Value = Dropdown2.Selected.Value && StartsWith(Title, TextInput1.Text), 'Created By'.Email = User().Email ), IsBlank(DropDown4.Selected.Value) || Priority.Value = Dropdown4.Selected.Value )

It uses a single filter function, but different conditions are applied, based on the selected tab. What is not dependent on the selected tab are the conditions to filter the Priority column.

Was this reply helpful? Yes No

Join the conversation