I have a sharepoint list in which an employee can add items to that list and submits the form. I then want their manager to use the same list but via a different button so they cannot review the list they have just submitted. On the list I have a column with all of the managers names as a choice. I have set a variable as vuser=User().UserName on startup of the App but have tried, Search, lookup and filter commands to confirm if Vuser is actually in the Manager Choice list. Then if it is to navigate to the edit screen for that form or if the name is not on the list then to do nothing. Any help appreciated. It has to be something simple. Using a button with Onselect as:-
If(LookUp('Source List', Manager=Vuser, Navigate(ManagerEdit,ScreenTransition.None), Navigate(PayrollEdit,ScreenTransition.None))
Where Manager is a Choice Column in the source list and includes all of the manager names.
OnStart
Set(VUser,Lower(User().FulllName)
OnSelect:
If(LookUp('Source List', Manager.Value=Vuser, Navigate(ManagerEdit,ScreenTransition.None), Navigate(PayrollEdit,ScreenTransition.None))
you have to use ".Value" with choice type colum.
It won't let me add .value or .txt and coming up with an error when I leave those out. Incompatible types for comparison, the left value is a table and the right value is a text
I changed the list (ManagerSelect) to be just a text column with all of the names and renamed the column as ManagerSelect
If(LookUp('ManagerList',ManagerSelect=Vuser,Navigate(HREdit,ScreenTransition.Cover),Navigate(PayrollEdit,ScreenTransition.Cover))
Now coming up with Unexpected characters. The formula contains 'ParentClose' where 'EOF' is expected
You might be missing a closing parenthesis at the very end
I have tried all combinations of ), at the end, in between and everywhere. Still no joy.. I thas to be something to do with source, column and variable but tried all variations
User | Count |
---|---|
160 | |
84 | |
68 | |
63 | |
61 |
User | Count |
---|---|
211 | |
146 | |
95 | |
82 | |
67 |