cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Multiple filters in Gallery

Hi,

 

I'm very new to Powerapps and I'm stuck with something that is probably very easy to get round.

 

I'm struggling with adding another filter in my gallery. I want to show only the user logged in and his/her assigned task by using the following formula (This works fine) 

Filter('GL Account', Lower('Finance Approver'.Email) = Lower(User().Email))

However, I would also like to filter the status on "New" and "Rejected" (Not the ones that are "Approved".

 

How can I add this extra filter with 2 conditions? 

 

Help is much appreciated 🙂

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Hi @Anonymous ,

Could you please share a bit more about the 'GL Account' data source? Is it a SP List?

Could you please share a bit more about the Status column? Is it a Single text type column or a Choice type column?

 

Based on the formula that you mentioned, I suppose that the 'GL Account' data source is a SP List, is it true?

 

I have made a test on my side, please take a try with the following workaround:

1. If the Status column is a Single text type column in your SP List:

Please modify your formula as below:

Filter(
'GL Account',
Lower('Finance Approver'.Email) = Lower(User().Email),
Status <> "Approved" /* <-- Add formula here */
)

2. If the Status column is a Choice type column in your SP List:

Please modify your formula as below:

Filter(
'GL Account',
Lower('Finance Approver'.Email) = Lower(User().Email),
Status.Value <> "Approved" /* <-- Add formula here */
)

 

Please take a try with above solution, check if the issue is solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Community Support
Community Support

Hi @Anonymous ,

Could you please share a bit more about the 'GL Account' data source? Is it a SP List?

Could you please share a bit more about the Status column? Is it a Single text type column or a Choice type column?

 

Based on the formula that you mentioned, I suppose that the 'GL Account' data source is a SP List, is it true?

 

I have made a test on my side, please take a try with the following workaround:

1. If the Status column is a Single text type column in your SP List:

Please modify your formula as below:

Filter(
'GL Account',
Lower('Finance Approver'.Email) = Lower(User().Email),
Status <> "Approved" /* <-- Add formula here */
)

2. If the Status column is a Choice type column in your SP List:

Please modify your formula as below:

Filter(
'GL Account',
Lower('Finance Approver'.Email) = Lower(User().Email),
Status.Value <> "Approved" /* <-- Add formula here */
)

 

Please take a try with above solution, check if the issue is solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Anonymous
Not applicable

Thanks Kris! That worked perfect!

 

Data source is a SP site and Status field was "Choice". 

Would you know how I could filter the list based on 2 out of 4 status?

 

Much appreciated 🙂

 

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (42,923)