Skip to main content

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?

9071iA15D1D4F6C469D5A.png


 


 


 

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

@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.

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings