Unanswered

Can#t combine two filters

(0) Share

Report

Posted on by EOberfrank

Hello together,

I made a galley with users from a sharepoint list who have different roles. Then I created a screen where you can filter the users with the input of text box.

Each filter on it's one works fine (Falter A and Filter B), but if I try to combine them (Filter C), the gallery shows errors and stay empty. What did I miss?

Filter A: Filter('LX2 - User'; txt_UserConf_Search.Text in User.DisplayName)

Filter B: Filter('LX2 - User';Not(Role.Value = "Superadmin"))

Filter C: Filter('LX2 - User'; And (Not(Role.Value = "Superadmin"); txt_UserConf_Search.Text in User.DisplayName))

Best regards

EOberfrank

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

v-mengmli-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @EOberfrank ,

Please try this:
Filter('LX2 - User'; Not(Role.Value = "Superadmin")&&txt_UserConf_Search.Text in User.DisplayName)

Best regards,
Rimmon
EOberfrank 63 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the reply.
I tried it with your suggestion but now it states "Invalid number of arguments: received 1, expected 2 or more."
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @EOberfrank ,

Could you please show me the screenshot and where do you put the code on?
EOberfrank 63 on at

Like
a
(0)

Report
Copy link

Link copied!

I think there was a little error in my PowerApps. I quit PowerApps, closed the brwoser and when I started it again your solution works. Thank you for the help. 🙂