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:

General Questions

All responses (3)

Answers (1)

SaiAnugrah_7860 2 on at

Like (0)

Report

Filter Gallery Based on the User and user location mentioned in powerapps from sharepoint list

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 .
StephCORKING 203 on at

Like (0)

Report

Re: Filter. gallery view based on user selection

Hi @eka24

Brilliant!!

thank you so much 🙂

Steph
Verified answer

eka24 20,921 on at

Like (1)

Report

Re: Filter. gallery view based on user selection

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.