Filter function breaking for some users

(1) Share

Report

Posted on by Petar Hr.

Hi community,

I'm encountering an issue where a dropdown is working for some users and it's breaking for others. There is no visible difference between the user profiles in Intra - they have the same setup and privileges.

The dropdown has the following setup for it's Items property:

Filter(
    'Roles List',
    'Person'.Email = User().Email && Not(
        Role in Filter(
            'Entry List',
            'Created By'.Email = User().Email
        ).Role
)

I get a delegation warning on the second part, however I'm working with a small list of values (~ 130 items in both lists). Both data sources are Share Point lists. Users also have the same access to the list.

For the working group, the dropdown correctly shows several roles for which the user has not created an entry. For the non working group - the list doesn't display any items, although it should.

I've played around and hard-coded different values for User().Email to directly test it in the Power Apps Studio and I get the same result as the end users.

Do you have any idea what may be the root cause for this behavior?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Nandit 1,568 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi Petar Hr.,

Can you please try the below code and see it works for you?

Filter( 'Roles List', 'Person'.Email = User().Email && Not( Role in Distinct(Filter( 'Entry List', 'Created By'.Email = User().Email ), Role) )

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No
Petar Hr. 18 on at

Like (0)

Report
Copy link

Link copied!

Hi Nandit,

Apologies for the long wait of my reply.

Unfortunately I'm still searching for an active case where the users still experiences the issue so I can test the suggested code.

For now both the suggested and original codes work (not exactly sure why) for the accounts that previously had the issue. If I manage to locate & test with an account that confirms your solution, I'll mark the reply as an answer.

Regards,

Petar Hr.

Was this reply helpful? Yes No
Petar Hr. 18 on at

Like (0)

Report
Copy link

Link copied!

Hi again,

As I submitted my last answer a new user complained about it. :D

So, it's confirmed - Distinct produces the same output as the original code. Still in search for a solution to understand what is wrong with the code.

Was this reply helpful? Yes No