Unanswered

Role Based Home Screen View

(0) Share

Report

Posted on by AdaEloka

Hello everyone,

I'm trying to filter my app home screen to show certain boxes according to the assigned role of the user from a sharepoint list. The sharepoint columns are multi-person columns. I used the "in" operator mostly. However, I ran into a problem with user emails that were not completely unidentical for example ejideofor@abc.com and eofor@abc.com or kukaoha@abc.com and kcukaoha@abc.com What happened is that it seems that eofor is "in" ejideofor, therefore it displays the result that is meant to be for ejideofor to eofor. I believe the "=" operator will help to solve the problem but i'm not exactly sure how, considering that it's a multi-person column. I'll need to compare each email in the multi-person column to the User().Email. This is the code I have now...

//This filters the home menu according to the role of the logged in user.
If(
 User().Email = varVoucherRolEmail,
 Filter(
 colHomeMenu,
 varVoucherRoles in SeenBy
 ),
 User().Email in varDeptHead,
 Filter(
 colHomeMenu,
 varDeptHead in SeenBy && User().Email in varDeptHead
 ),
 User().Email in varMemEmails && !(User().Email in varUnitHead),
 Filter(
 colHomeMenu,
 varMemEmails in SeenBy && User().Email in varMemEmails
 ),
 User().Email in varMemEmails && User().Email in varUnitHead,
 Filter(
 colHomeMenu,
 varMemEmails in SeenBy && User().Email in varMemEmails || (varUnitHead in SeenBy && User().Email in varUnitHead)
 ),
 Filter(
 colHomeMenu,
 varUnitHead in SeenBy && User().Email in varUnitHead
 )
)

varUnitHead, varDeptHead and varMemEmails are each concatenated into a string for example varUnitHead is Concat(ThisItem.UnitHead, Email, "; ") and so on. Thank you so much.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@AdaEloka - consider using the exactin function instead of in.

Was this reply helpful? Yes No
AdaEloka on at

Like (0)

Report
Copy link

Link copied!

Hi @Amik ,
I already tried exactin, it still returns true since "eofor" is an exact match as a substring within the string "ejideofor."

I need something that will return false when the two strings are compared. I strongly believe that the = operator will do the trick...only I'm not sure how to use it in the code I already have...

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @AdaEloka - I do not think the problem has anything to do with email addresses partially sharing same the sequence of characters, I suspect it is your Variable.

As I understand it, you're using the below function to generate a single line string of each email attribute in your Mult-Choice SharePoint People column.

Concat(ThisItem.UnitHead, Email, "; ")

The purpose of the in function is to check if a string is exists within another text string or Table. You're doing the former, when what you should be doing is the latter. You should be checking a Table of email addresses, with each email address listed as a new line in that table.

To populate your Variable with a table of email addresses, rather than a single line concatenated string, you can leverage the split function:

Set( varUnitHead, Split( Concat( ThisItem.'UnitHead', Email & ";" ), ";" ) )

Or as a Context Variable if that's what you're using:

UpdateContext( { varUnitHead: Split( Concat( ThisItem.'Unit Head', Email & ";" ), ";" ) } )

Consider this approach and let me know if that solves the problem.

Was this reply helpful? Yes No