Sutekh
Workflow Hero

Retrieving specific information from one SP list based on the values from another

Afternoon all

 

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?

Querylist.png

 

 

 

0 Kudos
Reply
2 Replies
claudiaurbanski
Process Pupil

Re: Retrieving specific information from one SP list based on the values from another

Are you populating your variable Employee name as Display name? SO you don't get the claim and display name  i:0#.w|

0 Kudos
Reply
kunalpatel
Automation Master
Automation Master

Re: Retrieving specific information from one SP list based on the values from another

@Sutekh , you can follow below steps (assuming your Full Name field displays name as "LastName, FirstName"):

 

  1. Use Set Variable action and store current item's "Employee - Display Name" in the variable (you need to click on 3 dots and select Display Name from the drop down)
  2. Use that variable to filter your Starters list

Or you can use Query User Profile and variables to get the same format as Full Name and use it as a filter.

0 Kudos
Reply