Hi all,
When trying to filter, in this scenario, a SharePoint source - i am not getting the desired results and cannot figure out why..
Set ( _AvailableSites, Filter ( 'Data Capture Line Manager Assignments'.LocationNumber, _LoggedInUser in 'Data Capture Line Manager Assignments'.UserPrincipalName ) )
I want to only return a table of 'Location Number's that match the variable of the _LoggedInUser
I am expecting the following x4 Location numbers, based on the current value of the variable, but i am getting random or first records from the source instead in the variable collection.
What am I doing wrong!
As you can see the below do not match the above, which should be filtered by the corresponding UserPrincipleName from the _LoggedInUser variable
Solved! Go to Solution.
Hi @Anonymous
Set ( _AvailableSites, Filter ( 'Data Capture Line Manager Assignments', UserPrincipalName = _LoggedInUser , LocationNumber ) )
Hi @Anonymous
Set ( _AvailableSites, Filter ( 'Data Capture Line Manager Assignments', UserPrincipalName = _LoggedInUser , LocationNumber ) )
User | Count |
---|---|
157 | |
92 | |
80 | |
74 | |
57 |
User | Count |
---|---|
196 | |
166 | |
99 | |
95 | |
79 |