In Office365 user are present user with surname and first name.
In SharePoint list Rights_assignment users where surnames and first names are displayed in a column (Person_or_group).
Page recognizes who is currently using the page and accordingly should look in SharePoint list Rights_assignment whether he is entered there.
If yes, a gallery opens which is intended for admins, otherwise normal gallery.
My problem that I always get the value TRUE and first Navigate is selected even if the user is not listed in SharePoint list Rights_assignment.
As it looks, the code as written will always return a non-blank result, even if the surname of the Office365-Benutzer is not in the Person oder Gruppe display name.
How should it be?
If the result of the Concat function is not blank, the first Navigate function will be executed and the user will be redirected to the Dashboard_Admin screen. Otherwise, the second Navigate function will be executed and the user will be redirected to the Dashboard screen.
What am I doing wrong?
If(!IsBlank(
Concat(
Filter(
Rights_assignment;
'Office365-User'.MyProfile().Surname in 'Person_or_group'.DisplayName
);
'Person_or_group'.DisplayName;
""
)
);
Navigate(Dashboard_Admin;Transition.None);
Navigate(Dashboard;Transition.None)
);;
