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:

Building flows

I have the same question (0)

All responses (10)

Answers (1)

Sort by

v-yetonggu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
alie4hunt 38 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
alie4hunt 38 on at

Like (1)

Report
Copy link

Link copied!

Hi @v-yetonggu-msft ,

The date and time seems works in this format, but the error showing null when testing.

Was this reply helpful? Yes No
Verified answer

v-yetonggu-msft Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
alie4hunt 38 on at

Like (1)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @alie4hunt ,

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

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
alie4hunt 38 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
alie4hunt 38 on at

Like (1)

Report
Copy link

Link copied!

Hi @v-yetonggu-msft ，

Really appreciate, it works now !!! Was my mistake putting two same formulas.

Was this reply helpful? Yes No