Adddays update item using switch control

[cindelwood]

Hello, 

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

For example:

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"

My table:

My Flow:

The issue:

Any help would be greatly appreciated! 

[abm]

Hi @cindelwood 

What's the data type of Period Value column? Is this column type Text?

[abm]

Hi @cindelwood 

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.

Thanks

[cindelwood]

@AB 

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
ACTIVITY	Lookup (primary)	ACTIVITY
ACTIVITY SET	Lookup	ACTIVITY_x003a_Title_x0020__x002
DELIVERY MODE	Lookup	ACTIVITY_x003a_DELIVERY_x0020_MO
ESTIMATED DURATION (MINUTES)	Lookup	ACTIVITY_x003a_ESTIMATED_x0020_D
PERIOD	Lookup	ACTIVITY_x003a_PERIOD
FACILITATING DEPARTMENT	Lookup	ACTIVITY_x003a_FACILITATING_x002
FACILITATOR(S)  1= Primary 2 = Backup	Lookup	ACTIVITY_x003a_FACILITATOR_x0028
ASSIGNED FACILITATOR	Person	ASSIGNEDFACILITATOR
Date Created	Date & Time	_DCDateCreated
NEW HIRE NAME	Choice	NEWHIRENAME
STATUS	Choice	STATUS
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'

[abm]

Hi @cindelwood 

Ah ok that make sense now. I will send you a screenshot of the flow.

Thanks

[abm]

Hi @cindelwood 

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?

Thanks

[cindelwood]

I wasn't sure which was best to look at so I captured 2 views:

View 1

View 2

[cindelwood]

Is my adddays correct?

addDays(triggerOutputs()['NEWHIRESTARTDATE'], 0, 'dd-MM-yyyy')

[abm]

Hi @cindelwood 

Yes I can see FIRST DAY is returned but why it didn't evaluated the switch? 

[abm]

Hi @cindelwood 

Also make sure there are no spaces at the end of FIRST DAY under the Equals mapping.

[cindelwood · Accepted solution]

@abm 

I had a space after FIRST DAY! I got it to work now. Thanks so much for your help! 

[abm]

Hi @cindelwood 

Thanks for the update. I had a doubt about it hence I asked about it earlier.

Thanks