Filter function set conditional

(0) Share

Report

Posted on by Kirsten2

383

Hello,

I want to filter gallery items based on whether a user's email is in a permission's SharePoint list. If not in the permission list, I want to limit the gallery items to only "In-progress" and their own customer email. Otherwise, if in the permission list, I want the user to see all items. I need help writing the conditional logic to add to the filter function under the Items property for the gallery.

Filter( Source,

If(IsBlank(LookUp(Permissions,Email=User().Email)), Status.Value = "In-progress"),

If(IsBlank(LookUp(Permissions,Email=User().Email)), 'Customer Email' = User().Email)

)

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

WarrenBelz 156,536 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Kirsten2 ,

Try this

With( { wAccess: !IsBlank( LookUp( Permissions, Email = User().Email ).Email ) }, Filter( Source, (wAccess || Status.Value = "In-progress") && (wAccess || 'Customer Email' = User().Email) ) )

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.

MVP (Business Applications) Visit my blog Practical Power Apps
Kirsten2 383 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks! This almost works for me. I tried typing in just the customer email as a conditional and I only see that customer email when not on the permission list, which is great!

However, the "in-progress" is not working for me. It might be because I have as part of the filter a dropdown for the status associated with it. Where I say in the filter:

Status.Value = Dropdown2.Selected.Value

Is there a way to make the selected value only "In-progress" for emails not on the permissions list?

When I tried your way above, I didn't get an error for the code associated with 'In-progress", but I didn't get an records appear in the gallery for me when doing that. That's why I think there is an issue with having a dropdown as part of the filter as the problem. I want to keep the dropdown, but have "In-progress" as the only option for emails not on the permission list.
Kirsten2 383 on at

Like
a
(0)

Report
Copy link

Link copied!

I tried to edit the Item Property of the dropdown, but got an error.

If(IsBlank(LookUp(Permissions, Email=User().Email)), "In-progress",Choices(Orders.Status))

Error:
Expected Table value
WarrenBelz 156,536 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

HI @Kirsten2 ,

Sorry but I am not clear exactly what you need - if the user is not in the permissions list, the records are restricted to a Status of "In progress" and their email in 'Customer Email'.
Verified answer

developerAJ 4,763 on at

Like
a
(1)

Report
Copy link

Link copied!
With( { wAccess: !IsBlank( LookUp( Permissions, Email = User().Email ).Email ) }, Filter( Source, wAccess || Status.Value = "In-progress" || 'Customer Email' = User().Email ) )

if user need to see their records along with in progress records This should work

With( { wAccess: !IsBlank( LookUp( Permissions, Email = User().Email ).Email ) }, Filter( Source, (wAccess || (Status.Value = "In-progress" && 'Customer Email' = User().Email) ) )

This is for user records with only inprogress status
Kirsten2 383 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks! This worked. You just forgot one parathesis at the end. Thank you a bunch!