Answered

Create event (V4) Date time format

(1) Share

Report

Posted on by alie4hunt

I'm trying to set up that when my approval is granted, SharePoint will receive the latest status update. Additionally, it should create an event in Outlook to let others know that this time slot is already booked. I'm not sure if my parameters are correct (I suspect my date string format might be wrong). Should I be using "update event" instead of "create event"?

Categories:

Business Process Flows

All responses (10)

Answers (1)

alie4hunt 38 on at

Like (1)

Report

Re: Create event (V4) Date time format

Hi @v-yetonggu-msft ，

Really appreciate, it works now !!! Was my mistake putting two same formulas.
v-yetonggu-msft on at

Like (1)

Report

Re: Create event (V4) Date time format

Hi @alie4hunt ,

Please check whether the formulas entered for StartDate and EndDate in your create event are respectively:

convertTimeZone(outputs('Update_item')?['body/StartDate'],'UTC','Singapore Standard Time','yyyy-MM-dd HH:mm:ss')

convertTimeZone(outputs('Update_item')?['body/EndDate'],'UTC','Singapore Standard Time','yyyy-MM-dd HH:mm:ss')

I'm guessing you've written the same formula.

Best Regards,

Sunshine Gu
alie4hunt 38 on at

Like (1)

Report

Re: Create event (V4) Date time format

Hi @v-yetonggu-msft ,
I create 22 for the start date and end dates on 26, in SharePoint and the date print out in the email body shows the correct date, just the booking date are not in the correct one.
v-yetonggu-msft on at

Like (1)

Report

Re: Create event (V4) Date time format

Hi @alie4hunt ,

Please check that the start and end dates in your create event are the same day.

Best Regards,

Sunshine Gu
alie4hunt 38 on at

Like (1)

Report

Re: Create event (V4) Date time format

Hi @v-yetonggu-msft ,
It actually works and is able to update to Outlook, but why does it only create a single column instead of spanning from the start date to the end date?
Verified answer

v-yetonggu-msft on at

Like (2)

Report

Re: Create event (V4) Date time format

Hi @alie4hunt ，

Please try both expressions again:

convertTimeZone(outputs('Update_item')?['body/StartDate'],'UTC','Singapore Standard Time','yyyy-MM-dd HH:mm:ss')

convertTimeZone(outputs('Update_item')?['body/EndDate'],'UTC','Singapore Standard Time','yyyy-MM-dd HH:mm:ss')

Best Regards,

Sunshine Gu
alie4hunt 38 on at

Like (1)

Report

Re: Create event (V4) Date time format

Hi @v-yetonggu-msft ,

The date and time seems works in this format, but the error showing null when testing.
v-yetonggu-msft on at

Like (1)

Report

Re: Create event (V4) Date time format

Hi @alie4hunt ,

There is a problem with Start_Date and End_Date field references, please try this expression again:

convertTimeZone(outputs('Update_item')?['body/Start_Date'],'UTC','Singapore Standard Time','yyyy-MM-dd HH:mm:ss')

convertTimeZone(outputs('Update_item')?['body/End_Date'],'UTC','Singapore Standard Time','yyyy-MM-dd HH:mm:ss')

Best Regards,

Sunshine Gu
alie4hunt 38 on at

Like (1)

Report

Re: Create event (V4) Date time format

Hi @v-yetonggu-msft ,
Still the same after changing the expression
v-yetonggu-msft on at

Like (1)

Report
Re: Create event (V4) Date time format

Hi @alie4hunt ,

Please try this expression:

convertTimeZone(outputs('Update_item')?['body/Start_Date'],'UTC','Singapore Standard Time','yyyy-MM-dd HH:mm:ss') convertTimeZone(outputs('Update_item')?['body/End_Date'],'UTC','Singapore Standard Time','yyyy-MM-dd HH:mm:ss')

Best Regards,

Sunshine Gu