Filtering Gallery with Two Conditions - ACL and Dropdown

(0) Share

Report

Posted on by AkshayManke

Hello,

I have the below scenario where request help.

1. SP List as base data

2. Status Column in List containing options = ["Open", "Submitted", "Closed", "Send Back"]

3. App containing screen where gallery is location to see the items.

4. One ACL is created to check if the logged in user is there in the ACL list.

5. If the user is in ACL then show all items else show the items where the logged in user is owner.

Requirement: I have created a dropdown in the same screen with the Status "Active" and "Closed". If the value selected is "Active" then the gallery should show items other than "Closed", and if the status is "Closed" then it should show only items with status "Closed".

Below some test code but can someone please help to achieve this?

If (
 IsBlank(
 LookUp(
 'Admin Team',
 Name.DisplayName = VarLoginUserName
 )
 ),
 Filter(
 'Management App',
 'Owner'.DisplayName = VarLoginUserName && If( DD_Status_1.SelectedText.Value = "Active", Filter('Management App',Status.Value <> "Closed") , Filter('Management App',Status.Value = "Closed")) 
 ),
 If( DD_Status_1.SelectedText.Value = "Active", Filter('Management App',Status.Value <> "Closed") , Filter('Management App',Status.Value = "Closed"))

Thanks,

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @AkshayManke ,

Maybe something like this

With( { wAdmin: LookUp( 'Admin Team', Name.DisplayName = VarLoginUserName ).Name, wActive: DD_Status_1.SelectedText.Value = "Active" }, Filter( 'Management App', ( !IsBlank(wAdmin) || 'Owner'.DisplayName = VarLoginUserName ) && ( (wActive && Status.Value <> "Closed") || (!wActive && Status.Value = "Closed") ) ) )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
AkshayManke 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks a lot @WarrenBelz, I am getting the expected results through the code you shared. Many Thanks,

Regards,
Akshay

Was this reply helpful? Yes No