Filter. gallery view based on user selection

(0) Share

Report

Posted on by StephCORKING

203

Hi,

I have a gallery where, based on the user selection, the filter will be different. When the user selects the option that they want to see (from an icon), the variable is updated with the icon value and this will be used in the filter. But I'm sure the format in my items field is completely wrong!

Screen Shot 2021-03-19 at 13.00.58.png

My formula is:

Sort(
If(GallView = "1st Approval (Awaiting Price)",
Filter('Travel Approval Process','Pre-approved'.Value = "Approved" And 'Travel Approval Process',Approved.Value = "Pending")
,
If(GallView = "2nd Approval (Awaiting Ticket Issuance)",
Filter('Travel Approval Process',Approved.Value = "Approved" And 'Travel Approval Process','Tickets Issued'.Value= "No")
,
'Travel Approval Process')
),
Created,Descending)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

eka24 20,925 on at

Like (1)

Report
Copy link

Link copied!

Try this modified formula. If you still have issues, clarify if you have two Galleries and also state the code for the variable:

Sort(
If(GallView = "1st Approval (Awaiting Price",
Filter('Travel Approval Process','Pre-approved'.Value = "Approved" And Approved.Value = "Pending")
,
If(GallView = "2nd Approval (Awaiting Ticket Issuance)",
Filter('Travel Approval Process',Approved.Value = "Approved" And 'Tickets Issued'.Value= "No")
,
'Travel Approval Process')
),
Created,Descending)

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

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
StephCORKING 203 on at

Like (0)

Report
Copy link

Link copied!

Hi @eka24

Brilliant!!

thank you so much 🙂

Steph

Was this reply helpful? Yes No
SaiAnugrah_7860 2 on at

Like (0)

Report
Copy link

Link copied!

I am building a reception management system .

When the receptionist open the apps she needs to see the visitors of her current location .
For example : i have a list with receptionist email and their location .
john@xyz.com --> India
Jack@xyz.com -- > USA

So when John logs in i want to see the data of only India and not USA similarly vice versa . Please suggest i also have other filter for the gallery that are working fine based on locations , name , time , date etc . i need to fit in my current scenario additional into my gallery items property . Any suggestion would be highly appreciated .

Was this reply helpful? Yes No