Answered

Filtering gallery using variable

(0) Share

Report

Posted on by Izzet7

I've had this working previously, but somethings happened (I probably happened!) to stop it working...

I have a gallery with a list of stock items, I'm trying to filter a pop-up gallery to show all of those that have the selected item signed out...

I have a global variable of:

Set(varSelected, ItemGallery.Selected.ID)

The button on the main gallery is:

Set(varViewItemsUsers, true); < triggers the popup.

Set(varSelected, ThisItem.ID)

The new gallery is:

LookUp(UsersItemRequests, ID=varSelected && Status="Approved")

This should show a list of users that have selected item signed out but isn't, I've tried with ItemGallery.Selected.ID as well but nothing... I'm not sure what I'm missing or what I've done for it to stop working.

(Works fine for the forms I'm using, just not this gallery for some reason!)

Please help 😂

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Izzet7 ,

If that is a gallery you need

Filter( UsersItemRequests, Status="Approved" )

LookUp produces a Record, Filter a Table. Also if you use the ID, you will only get one record in the table.

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.
Verified answer

Izzet7 37 on at

Like
a
(0)

Report
Copy link

Link copied!

I've managed to get this working now using:
Filter(datasource, columnname in Galleryname.Selected.columnname && Status = "Approved")
Izzet7 37 on at

Like
a
(0)

Report
Copy link

Link copied!

Yeah I've sorted it, I'm sure I'd used Filter and it wasn't working either... I'd been staring at it so long that who knows atm! Cheers.
WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Izzet7 ,

Pretty much what I posted without knowing your exact requirements (you marked your post as the solution).