Share
ReportHi 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
Categories:
I have the same question (0)
All responses (
Answers (
24,769
