web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter with 2 conditio...

Power Apps

Answered

Filter with 2 conditions on Gallery

(0) Share

Report

Report

Posted on by Stefan3663

4

Hi there,

I am struggling to get my gallery to filter to 2 set conditions.

It is connected to an online Excel Sheet (table3)

I need the gallery to filter to the user and only "Active" projects in the Active? Column.

I have used the following formulas on the gallery so far, but it does not filter "Active" projects

Filter(Table3, 'Associate Email' = Office365Users.MyProfileV2().mail , "Active" in Lower('Active?'))

Filter(Filter(Table3, "Active" in Lower('Active?')), 'Associate Email' = Office365Users.MyProfileV2().mail)

I also have a little triangle at the top, so If someone can advise how to set this up so that it can deal with a larger data set would be amazing!

Looking forward to hearing back from you

kind regards

Stefan

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report
Hi @Stefan3663 ,

The "triangle" is a Delegation warning as both the in Filter and Lower() are not Delegable - you can try

Filter( Table3, 'Associate Email' = User().Email && StartsWith( 'Active?', "Active" ) )

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
Stefan3663 4 on at

Like (0)

Report

This is great! Worked like a charm. Thanks Warren

Was this reply helpful? Yes No

Join the conversation