Hi all,
I have an issue when using two filters on the Items property of a gallery.
I have a gallery hooked up to a SP list called 'DXCAccountAudit'. The two columns in the list I am trying to filter the gallery items on are 'Account Enabled' (yes/no field) and 'RequestedBy' Person and Group field (not set to multi selections)
On the items property of the gallery I have the following syntax:
Filter(DXCAccountAudit,AccountEnabled=true && DXCAccountAudit,RequestedBy.DisplayName = CurrentUser.Text)
DXCAccountAudit is my data connection to the SP list called 'DXCAccountAudit'
and 'CurrentUser' is a label within the app that has its text property set to User().FullName
When I use each filter separately (i.e without joining with &&, they work OK) but together I get the error:
Invalid argument type on filter of gallery items. Expecting Boolean,Number, Text, Overvaluation
Can anyone help.
I tried targeting the datacard within the gallery called 'Gallery2UserName' that is set to ThisItem.RequestedBy.DisplayName of the SP person or group field but I get a circular ref error as well.
