date time transpostion

(0) Share

Report

Posted on by Andrew_J

1,962 Moderator

Hi All,

I am have set up a meeting dates SP List and are using this to send meeting invites to the two SP groups with different team members. The data in the SP List is as follows:

I enter the date and time as below

I have finally got it work from a general point of view but when I write the date and time to other columns using the update item

and the expression

formatDateTime(outputs('Get_item')?['body/Start_Date_Time'],'dd/MM/yyyy HH:mm')

I get the meeting to appear in the calendar as taking place in February this year, which is not right.

There has to be problem in the expression that I am not seeing although it working.

Regards,

Andrew

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

schwibach 2 Moderator on at

Like (0)

Report

Re: date time transpostion

Hey,

try using this format 'yyyy-MM-ddThh:mm:ss' for the SharePoint list

Was this reply helpful? Yes No
Andrew_J 1,962 Moderator on at

Like (0)

Report

Re: date time transpostion

@schwibach

Thanks all sorted, I knew it had to be the date time formatting. It saves it to Teams but date is shown as being incorrect.

But i think that is down to the setting in that part of O365 that I do not have access to as I am an end user.

Thanks once again.

Andrew

Was this reply helpful? Yes No