I'm trying to build an automated flow that updates column 'Training Due Date' using adddays expression that is conditional based on values in columns 'NEW HIRE START DATE' and 'PERIOD'.
Where 'NEW HIRE START DATE' = "4/8/2022"
IF 'PERIOD' = 'FIRST DAY', then add '0' days to 'START DATE' > output = "4/8/2022"
If 'PERIOD' = 'FIRST WEEK', then add '7' days to 'START DATE' > output = "4/15/2022"
Any help would be greatly appreciated!
Solved! Go to Solution.
Forgot to mention that its case sensitive. So make sure your SharePoint value all are in Capital letters?
If not use expression to convert to toLower() or toUpper() under your switch case.
Thank you for your quick response! The data type for the Period column is a lookup. This is why I'm creating the flow in the first place.
Table 1 'Customer Relations Onboarding - IAM' is pulling in values from table 2 ' Onboarding Master Catalog'. The requirement is to have governance around when certain onboarding training activities should be scheduled within the 90-day onboarding process. 'Period' is the mandated time frame in which the training should be scheduled from the new hire's start date. Because Period is a lookup column, I'm trying to find a way to
My ultimate goal is to calculate the 'Training due date' based on new hire start date and the mandated 'Period'. Is there another way to achieve this?
Table 1 'Customer Relations Onboarding - IAM
|Column Display Name||Type||Internal ID|
|ESTIMATED DURATION (MINUTES)||Lookup||ACTIVITY_x003a_ESTIMATED_x0020_D|
|FACILITATOR(S) 1= Primary 2 = Backup||Lookup||ACTIVITY_x003a_FACILITATOR_x0028|
|Date Created||Date & Time||_DCDateCreated|
|NEW HIRE NAME||Choice||NEWHIRENAME|
|TRAINING SCHEDULED FOR||Date & Time||TRAININGSCHEDULEDFOR|
|NEW HIRE START DATE||Date & Time||NEWHIRESTARTDATE|
|TRAINING DUE DATE||Date & Time||TRAININGDUEDATE|
Table 2 'Onboarding Master Catalog version 2'
Looks like your mapping is correct. Could you check the run history and expand the Get Item output and check what's been returned. Could you post a screenshot?