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?)
Check out the on demand sessions that are available now!
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Features releasing from October 2020 through March 2021
Check out the Power Platform Community Highlights