Answered

Another multiple filtering question

(0) Share

Report

Posted on by andrew260z

Just looking at some other examples on this forum but struggling to get this statement right;

I have a toggle for a "Contractor" column being either "Yes" or "No" depending on a toggle on the page, can I somehow fit that into the Filter statement?

SortByColumns(
 Filter(
 VisitorSignInList,
 Lastname = SiteCode
 ),
 "SignInDate",
 If(
 SortDescending1,
 Ascending,
 Descending
 ),
 "SignInTime"
)

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Andrew,
Is your data from Sharepoint? Is your expression the Items property of a gallery or datatable?

Was this reply helpful? Yes No
andrew260z 38 on at

Like (0)

Report
Copy link

Link copied!

Yes that is right its a SharePoint list, data is presented in a gallery at the moment.

Was this reply helpful? Yes No
Verified answer

Mike8 1,330 on at

Like (1)

Report
Copy link

Link copied!
Hello andew260z,

Does this work for you?
SortByColumns( Filter( VisitorSignInList, Lastname = SiteCode&&Contractor=Toggle1.Value ), "SignInDate", If( SortDescending1, Ascending, Descending ), "SignInTime" )
In order to try it, you need to replace Toggle1 with the actual name of your toggle control

Was this reply helpful? Yes No
andrew260z 38 on at

Like (1)

Report
Copy link

Link copied!

Sorry for the delayed response - yes works, I didn't realise that was possible to do the compound conditions for a filter. Thanks!

Was this reply helpful? Yes No