Unanswered

Using filter gallery function across filtered tabs

(0) Share

Report

Posted on by Community Power Pla...

I have built an app that has a gallery that shows the status of tasks assigned which is filtered by a tab selection in the following manner.

varTabSelected=1: all tasks

varTabSelected=2: tasks assigned to me

varTabSelected=3: tasks pending my review

varTabSelected=4: tasks created by me

I also have a built-in filter function for the user in "all tasks" to filter down to the tasks they need. Thanks to @Drrickryp who provided this awesome code when I was trying to combine the user filter and the tab filter.

With({_items:SortByColumns(Filter('SP LIST NAME',('Due date' >= cldStart.SelectedDate && 'Due date' <= cldEnd.SelectedDate || cldStart.SelectedDate = Blank() && cldEnd.SelectedDate = Blank()) && (Progress.Value = StatusRadio.Selected.Value || StatusRadio.Selected.Value = Blank()) && (Priority.Value = PriorityRadio.Selected.Value || PriorityRadio.Selected.Value = Blank())

),"DueDate",Descending)},

If(vartabselected=1,_items,vartabselected=2,Filter('SP LIST NAME',User().Email in 'Assigned To'.Email),Filter(_items,User().Email in 'Assigned To'.Email,Progress.Value="Pending")))

Is there a way to make the user filter which works with Tab 1 - All Tasks, have the same functionality regardless of which tab is selected? Currently, the user is only able to filter the gallery when they are on Tab 1 - All Tasks. it doesn't work when the user is in Tabs 2-4.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report
Hi @Anonymous ,

I cannot see your data or model, but try this

With( { _items: SortByColumns( Filter( 'SP LIST NAME', ( ( 'Due date' >= cldStart.SelectedDate && 'Due date' <= cldEnd.SelectedDate ) || ( cldStart.SelectedDate = Blank() && cldEnd.SelectedDate = Blank() ) ) && ( Progress.Value = StatusRadio.Selected.Value || StatusRadio.Selected.Value = Blank() ) && ( Priority.Value = PriorityRadio.Selected.Value || PriorityRadio.Selected.Value = Blank() ) ), "DueDate", Descending ) }, Switch( vartabselected, 1, _items, 2, Filter( _items, User().Email in 'Assigned To'.Email ), 3, Filter( _items, User().Email in 'Assigned To'.Email && Progress.Value = "Pending" ), 4, Filter( _items, 'Created By'.Email = User().Email ) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks Warren. Everything seems okay until you get to the Switch portion.

Not sure if this helps. Here is the code for the OnStart of the app:

ClearCollect(colTabs,{ID:1,Name:"All Tasks",Logo:Icon.DocumentWithContent},{ID:2,Name:"My Tasks",Logo:Icon.LogJournal},{ID:3,Name:"Tasks Pending My Review",Logo:Icon.Publish},{ID:4,Name:"Tasks Created By Me",Logo:Icon.Person});Set(vartabselected,1);Set(varUser,User());Set(varSortColumn,"DueDate");Set(varSortDirection,Descending)

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous ,

A couple of stray characters in there (now removed) - see if it works now.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks @WarrenBelz ,

I tried the code above again (assuming the changes you made were there) but ended with the same result.

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

@Anonymous ,

One more character (I thought you might have spotted that one) removed - NotePad has no red lines . . .

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@WarrenBelz , thanks so much for the help with this. I tried again with the result but found the pesky culprit. The issue ended up being an extra parenthesis and a missing one. The one I took out is in red and the one that I added is green. After that it works perfectly. Thanks so much for the help with this one. It was a doozy for sure.

With(
{
_items:
SortByColumns(
Filter(
'SP LIST NAME',
(
(
'Due date' >= cldStart.SelectedDate &&
'Due date' <= cldEnd.SelectedDate
) ||
(
cldStart.SelectedDate = Blank() &&
cldEnd.SelectedDate = Blank()
(
) &&
(
Progress.Value = StatusRadio.Selected.Value ||
StatusRadio.Selected.Value = Blank()
) &&
(
Priority.Value = PriorityRadio.Selected.Value ||
PriorityRadio.Selected.Value = Blank()
))
),
"DueDate",
Descending
)
},
Switch(
vartabselected,
1,
_items,
2,
Filter(
_items,
User().Email in 'Assigned To'.Email
),
3,
Filter(
_items,
User().Email in 'Assigned To'.Email &&
Progress.Value = "Pending"
),
4,
Filter(
_items,
'Created By'.Email = User().Email
)
)
)

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

@Anonymous ,

That is actually not correct as far as the logic goes - it was one reversed bracket which I have now fixed.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@WarrenBelz
You are a life saver. I sincerely appreciate the help with this one.

Was this reply helpful? Yes No