I have a Site Workflow in SharePoint that queries a List with a Person or Group field called "Name" and compares to another List and the Created By field. The filter for the query that I cannot get working is:
Name (Person or Group field) = Created By (Person or Group field)
This query always returns an empty result. When I have emailed both values to me for debugging purposes, they match perfectly, so it looks like the query should return values.
Would anyone know what I'm missing? This one has me stumped.
Solved! Go to Solution.
To resolve the issue you're looking at you'll want to filter based on the user ID number rather than the login name for the user. To do this, use a set variable action to set a text or integer variable to equal the return from your person or group variable. You'll see an ellipses to the right of the variable when you specify the variable to set. Clicking this will allow you to set the return type for the variable. You'll see the option to return the person or group as a user ID Number. Filtering your list by this should get you to where you can filter the list properly:
Thank you for your reply! I'm still having issues with the query unfortunately; I'm not sure how to change the highlighted field so that it looks at the User ID Number instead of the claim identifier. The variable "tempHousingUniqname" is a Person or Group field.
Thanks for your help!
Brent's solution worked, thanks Brent!
What I did not realize is that even though the "Created By" field shows the claim identifier, if you follow Brent's solution, it will match up based User IDs, not by the claim identifier.