Gallery does not filter out Office365 user if user has no profile picture

[Liebmann_Attila]

Hi Community, 

I am aiming to make a Gallery and filter out people that are in the same district as the User that is currently using the tool. Only people present in the same district should show up and user should not show up for himself/herself.

To identify the user, I have added the Office365Users Connector and am using User().Email
I have a user Database from SharePoint, where Email address is stored along with the aforementioned District.
Sharepoint Collumns: 
US - Project - Dataset - Name of my SharePoint list.
Email - exact email address of user
District - E.g.: DistrictA, DistrictB, DistrictC ... 
Name - Nickname of the users


Sort(

    Filter(

        'US Project - dataset',

        Email <> User().Email &&

        District = LookUp('US Project - dataset', Email = User().Email, District)

    ),

    'Name ({Name})'

)

For some reason what happens is that when a user has a profile picture set in Outlook (or rather in office 365) then the filter works correctly, and the user is excluded from the gallery for himself/herself , and everybody else in the same district still shows up. 

The problem is however if the user does not have a profile picture, then the user still can see himself/herself amongst the other members of the district he/she belongs to. 


Could somebody please help me figure out why this is happening?
I have gone through a few iterations already but with no success. 

Thank you in advance for your advice. 

[DBO_DV]

Hey @Liebmann_Attila, 

Sort(
    Filter(
        Filter(
            'US Project - dataset',
            District = LookUp('US Project - dataset', Email = User().Email, District)
        ),
        Email<>User().Email),
    'Name ({Name})'
)
 

Try this. Maybe by separating the two filters it will work better. 

[Liebmann_Attila]

Hi @DBO_DV , 

thank you for the suggestion. I have tried to change; accordingly, I even might have tried something similar before. Unfortunately, it does not solve the issue. Filter works for me correctly as I have a profile picture, but for user without profile picture in outlook district is filtered but user shows up for himself. 

[DBO_DV]

Have you tried creating a Collection with the Filtered data and then Removing the records with User().Email as Mail?

[Liebmann_Attila]

Hi @DBO_DV , 
no, am not really familiar with collections or how to create one in this case. 

[DBO_DV]

Let me help you out, 

ClearCollect(colDistrict, 
    Sort(
        Filter(
            'US Project - dataset',
            District = LookUp('US Project - dataset', Email = User().Email, District)
        ),
    'Name ({Name})'
    )
);
Remove(colDistrict,LookUp(colDistrict,User().Email=Email));

you can use colDistrict then as a table/datasource.

[Liebmann_Attila]

When entering the formula the system could not comprehend. 

"The expression was intended to clear and collect data from the 'US Project - dataset', filter and sort it based on certain conditions, and then remove specific rows from the collection. However, there are multiple errors in the expression including missing operators, invalid arguments for functions like ClearCollect, Sort, LookUp, and Remove, incompatible types for comparison, and unrecognized variable names like 'colDistrict' and 'Email'. Additionally, there is a warning about delegation issues with the 'Sort' function on large datasets."


I assume it is because colDistrict. Is that a command? Would there be any naming conventions needed in order for it to work ? 

[DBO_DV]

colDistrict is the Name of the Table that we are Creating. you need to put this formula inside of a Button or controll with OnChange. 

ClearCollect(colDistrict, 
        Filter(
            'US Project - dataset',
            District = LookUp('US Project - dataset', Email = User().Email, District)
        )
);
Remove(colDistrict,LookUp(colDistrict,User().Email=Email));

Try it like this without the sorting. the sorting can be added at a later stage. 

[Liebmann_Attila]

Could it be placed in the Gallery Items property ? 
I would want to avoid any action the user has to perform in order to sort or filter. Results should pop up for users when lunching the tool based on their profile already according to their district. 

[DBO_DV]

You can put it in the OnStart Property of your app. 

The loading time might be a bit longer but that shouldn't be a problem. 

then you'll just add 

colDistrict

in Data source in the Gallery.