Hi all,
Having some issues filtering a SQL data source with the following formula:
ClearCollect(PITeamMembers , Filter(
'[HRfact].[vwPIHierarchy]',
_SelectedLocationNumber in 'Location Number'
) )
I am getting a very strange error. Basically, i want to either
- create a collection of only the items from the SQL source column 'Location Number' that are equal to the variable _SelectedLocationNumber
- Or - skip making the collection, and filter the gallery to only show the SQL source column 'Location Number' that are equal to the variable _SelectedLocationNumber
And I am getting the following error:
Error for option 1:
Error for option 2:
Filter(
'[HRfact].[vwPIHierarchy]',
_SelectedLocationNumber in 'Location Number'
)
