I have a list which I've created called 'Leavers'. When a user enters a value in 'Employee' I'm trying to get my Workflow to return the employees 'Start Date' from a list called 'Starters' so that I could use that information in a Calculate Date action.
I thought the best approach would be to use a 'Query List' action and then filter the results.
So I configured it as below, the action is pointing at the Starters list. Full name is a field on Starters which - surprise surprise - shows the Full Name of the staff member. I stored the employees name field from the 'Leavers' list in a variable called 'Employee Name' and thought I could filter? Then I set the output to store in a variable called 'Start_date', but what I'm getting back is:
i:0#.f|xxxbershipprovider|xxx9 - employee name
01/01/0001 00:00:00 - start date
Where am I going wrong or could anyone suggest a better approach?
@Sutekh , you can follow below steps (assuming your Full Name field displays name as "LastName, FirstName"):
Or you can use Query User Profile and variables to get the same format as Full Name and use it as a filter.