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:

Using Apps Using Formulas

Connecting to Data

All responses (3)

Answers (0)

Petar Hr. 18 on at

Like (0)

Report

Filter function breaking for some users

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.
Petar Hr. 18 on at

Like (0)

Report

Filter function breaking for some users

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.
Suggested answer

Nandit 1,563 Super User 2025 Season 1 on at

Like (0)

Report
Filter function breaking for some users

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!