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......
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?)
Keep up to date with current events and community announcements in the Power Apps community.
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.
Check out the latest Community Blog from the community!