SortByColumns and Filter

(0) Share

Report

Posted on by AuburnMist

239

Hello,

I am working on developing an app to record employee leave and overtime.

I have a gallery where the items displayed are only those belonging to a selected employee (selected from a list box control).

I have this formula:

SortByColumns(Search(TEMPO_Leave,LBEmployeeName.Selected.Result,"Name"),"StartDate",If(SortDescending,Descending,Ascending))

Now I want to add drop downs next to the gallery where the supervisor can filter the items based on leave type or overtime type.

I modified the formula to:

SortByColumns(Filter(TEMPO_Leave,LBEmployeeName.Selected.Result,"Name",(LeaveType.Value=drpLeaveType.Selected.Value||drpLeaveType.SelectedText.Value=Blank())),"StartDate",If(SortDescending, Descending, Descending))

I am not getting any error messages, but what is happening is that the gallery displays only the selected leave type (ex: Vacation), but for ALL employees in the supervisor's team, and not just the employee who's name has been selected in the List Box control.

I cannot understand why it stopped pulling only those from the selected employee.

Can someone provide assistance on this?

Thank you so much!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,007 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @AuburnMist ,

I am sure what you are doing with "Name" in there, but suspect you want this

SortByColumns( Filter( TEMPO_Leave, Name = LBEmployeeName.Selected.Result && ( LeaveType.Value=drpLeaveType.Selected.Value || drpLeaveType.SelectedText.Value=Blank() ) ), "StartDate", If( SortDescending, Descending, Descending ) )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
AuburnMist 239 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you Sir! Worked like a charm!

Was this reply helpful? Yes No