Unanswered

Using Toggle to filter data on Data Table

(1) Share

Report

Posted on by ddow2788

I want to make my toggle switch filter the data on my table. I have the formulas set on my toggle switch but I can't figure out how to connect my table to the toggle. I provided a picture of what I am trying to do. The idea is when the toggle is on it will show one set of data and when the toggle is off it will show another set of data.

Categories:

Building Power Apps

Screenshot (34).png

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

ANB 7,223 Super User 2025 Season 2 on at

Like (1)

Report
Hi @ddow2788 , You can try this:

If(Toggle1.Value = true, Logic for Item, Toggle1.Value = false, Logic for Item)

OR

If(Toggle1.TrueText = "On", Logic for item, Toggle1.FalseText = "Off", Logic for item)

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

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.👍

Thanks,
ANB

Was this reply helpful? Yes No
madlad 2,637 Moderator on at

Like (0)

Report
Hi!

The best way to do this would be by actually referencing the toggle's value within the filter statement, something like:

If( *YourToggle*.Value, Filter( *YourDataSource*, *Condition1* ), Filter( *YourDataSource*, *Condition2* ) )

^Place this in the table's items property, and replace everything *surrounded by asterisks* with the appropriate values

Hope this helps! 🙂

Was this reply helpful? Yes No