Hey
I have this line of code in my ONSTART function:
ClearCollect(collAppUsers;Administratörer_SystemApp);;Set(IsUser;CountRows(Filter(collAppUsers;Lower(Rubrik) =Lower( User().Email))) = 1)
It checks if a useremail is in a sharepoint list (called administratörer_systemapp)
Then i put this on a button visible function
If(IsUser;true;false)
So if the users email is part of a list, then the button is visible.
This works great for me.
But now i have a need of adding another list to control other buttons that should be visible or not based on if the users email is part of that list.
How to add another "on start" line of code like the one above. i cant find a way of just adding it after the current one.
This is the "new" code with new list and new variable
ClearCollect(collAppUsers;AdminCreator_Systemapp);;Set(IsCreator;CountRows(Filter(collAppUsers;Lower(Rubrik) =Lower( User().Email))) = 1)
And then the idea is to put this on some buttons visible function
If(IsCreator;true;false)
But how to add this line of code after the one i already have?
I have tried ";" "&" ";;" and i still get different errors. What method is correct?
Solved! Go to Solution.
Hi @Oskarkuus
Double semi-colons should work for you (;;). Can you describe the error you see when you use this syntax?
screenshot: http://prntscr.com/ng7t8e
this error is what i get
can you see from this what i am doing wrong?
the error message is translated to: Function Lower contain arguments that are wrong......
Hi @Oskarkuus
Can you confirm what Rubrik is in your formula? Is this a field in colAppUsers? If so, what's the data type of this field (is it a text field?)
User | Count |
---|---|
137 | |
129 | |
76 | |
72 | |
70 |
User | Count |
---|---|
211 | |
200 | |
64 | |
63 | |
54 |