Forum Discussion

rautchetan27's avatar
rautchetan27
Brass Contributor
Jun 03, 2020

Filter query in workflow sharepoint

I am using filter query in workflow to get items from List,

my column name is Vendors which having type of Group/users and I am making following query on Vendors Column

 

Vendors eq '@{variables('varGroupName')}'

 

but I am not getting result, I have matching data in list which should return at least one record from list.

 

is this due to my list item column type is Group/Users and I am comparing it with string?

i want to compare it with string then what changes need to do?

My groups displayname is same as string I am comparing...how to make comparision in query?

Lists
SharePoint Online

1 Reply

  • Sudharsan K's avatar
    Sudharsan K
    Iron Contributor
    Jun 12, 2020
    Hi, since it is like a lookup column, you cannot use the field name directly, it has to be expanded and the expanded field has to be used. If you are filtering using the user/group id then it has to be Vendors/Id eq '@{variables('varGroupName')}'. If you are using the user/group name then it has to be Vendors/Title eq '@{variables('varGroupName')}'

Resources