Announcements
hello!
I'm trying to filter an equipment's table using a toggle. It seems pretty simple but the column I want to sort it by is actually linked to another tables called "equipment types". IDK how to link the 2. I want the toggle to display just the "desk" equipment types when it is checked and when its no to display all the equipment.
Also the "equipment types" is a lookup column so it uses the column ID in the equipment's table.
Hi @Littleone145
If [equipment types] not a column in your Equipment table, i suggest to add then you can sort the table by it.
Gallery item might be:
If(Toggle1.Value,Filter(AddColumns(Equipment, "Type", LookUp(RenameColumns(Equipment types, "ID", "UID"), UID = ID).equipmenttype), Type= "desk"),Equipment)
@Kimii I do already have it as a column, its a foreign key refencing my lookup table.
LookUp(equipment types, ID = ThisItem.ID).equipmenttype
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 405 Super User 2026 Season 2
Mohsin Ali 368
WarrenBelz 244 Most Valuable Professional
