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
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
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.
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......
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand