Create a SharePoint list item when an Office 365 event is added or updated - What am I doing wrong

[NeedHelp88]

Hello all,

I am very new to power automate and I am attempting to use a template to help with automatically updating/populating a SharePoint list with calendar entries from a Outlook calendar.

I have attached a could of snips of the errors that I am getting but ultimately not too sure what I need to do to make this happen. I also had a query regarding the way I format the "Destination time zone". Do I use "(UTC+10:00)Sydney, Australia" OR "(UTC+10:00) Eastern Standard Time (Sydney, Australia). I found both formats online and not sure if this is causing any issues. 

The formatDateTime trigger is the following:  formatDateTime(triggerBody()?['Date'], 'UTC', 'Eastern Standard Time', 'HH:mm')

TIA for your advise help.

 

 

[Expiscornovus]

Hi @NeedHelp88,

Like the error suggests, the formatdatetime function expects three parameters and not four. And the purpose of this function is to return a datetime stamp in a certain format.

Looking at the four parameters you are inputting in the expression are you sure you don't want to be using a converttimezone function instead?

The convertTimeZone function, accepts 4 parameters like below (which looks a lot like what you are using in your expression):

convertTimeZone('<timestamp>', '<sourceTimeZone>', '<destinationTimeZone>', '<format>'?)

convertTimeZone(triggerBody()?['Date'], 'UTC', 'Eastern Standard Time', 'HH:mm')

[Expiscornovus · Accepted solution]

Hi @NeedHelp88,

I had another look at your setup. I am pretty sure you can just type a format in that format string field as a custom value. Do make sure it matches the format the SharePoint list expects for your list item fields.

The previous reply from be useful if you want to use expressions instead of actions, but those expressions are not needed for your setup 😅

[NeedHelp88]

Hi @Expiscornovus ,

Thank you for your help. I have just taken out the expressions, just used the options available and the flow now working.

I am now having another issue that the time that is being input into my MS List is now substantially out.

The items are being input on the correct dates but they are not out on time. 

An item that I recently tested was put in for 11am and would show as 9pm.

 

I have used the correct UTC for the destination. Any ideas?

Thanks 🙂

[NeedHelp88]

Hi @Expiscornovus,

I think that I have fixed it. I have just changed the Destination Time Zone to the same as the source. I thought to myself that I didn't want to add the timezone to what I already had, I am just wanting to essentially copy likeness for likeness and it appears to have worked.

[v-xiaochen-msft]

Hi @NeedHelp88 ,

Hope you are well.

If the issue has been solved, you could mark the correct reply to close the case.

Best Regards,

Wearsky