V4CalendarPostItem Date time not valid

(0) Share

Report

Posted on by VentiloFred

Hello everybody,

I read some of messages, problems about this but i tried different solution to use V4CalendarPostItem

I have every time this error:

My regional settings on SharePoint, computer and Outlook are the same

I tried V2 and work very well but a need more fonctions

Do you have a solution?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Al_10 1,691 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@VentiloFred

I tested on my side your code and it works fine.

You can try to send dates in a specific format (replace commas with semicolons for Europe):

With({ wFirstDate: DateAdd( Now(), TimeZoneOffset(), Minutes ), wSecondDate: DateAdd( Now(), 10+TimeZoneOffset(), Minutes ) } , Office365Outlook.V4CalendarPostItem( LookUp(Office365Outlook.CalendarGetTables().value, DisplayName = "Calendar").Name, "Test Post item", Text(wFirstDate, "yyyy-mm-ddTHH:mm:ss"), Text(wSecondDate, "yyyy-mm-ddTHH:mm:ss"), "(UTC+01:00) Brussels, Copenhagen, Madrid, Paris" ) )

If that does not work, I don't have any other ideas.

Was this reply helpful? Yes No
AJ_Z 3,711 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Have you checked your browsers Language UI Settings chrome can be funny
If my comment is helpful please like/kudo it to make me smile 🙂 and if it is your solution please click accepts as solution

Was this reply helpful? Yes No
VentiloFred 4 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your time, but i have the same problem 😞

Was this reply helpful? Yes No
VentiloFred 4 on at

Like (0)

Report
Copy link

Link copied!

It's just a language setting? I don't thing is an influence for this, i don't see a parameter for time zone in Chrome. I made a test (first time) with my phone and i have the same problem
Thanks for you contribution

Was this reply helpful? Yes No
Al_10 1,691 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@VentiloFred

i got other ideas that may work for you (both work fine on my side)

Office365Outlook.V4CalendarPostItem( LookUp(Office365Outlook.CalendarGetTables().value, DisplayName = "Calendar").Name, "Test Post item", Text(Now(), DateTimeFormat.UTC), Text(DateAdd( Now(), 10, Minutes ), DateTimeFormat.UTC), "(UTC+01:00) Brussels, Copenhagen, Madrid, Paris" )

or

Office365Outlook.V4CalendarPostItem( LookUp(Office365Outlook.CalendarGetTables().value, DisplayName = "Calendar").Name, "Test Post item", DateTimeValue(Text(Now(), DateTimeFormat.UTC)), DateTimeValue(Text(DateAdd( Now(), 10, Minutes ), DateTimeFormat.UTC)), "(UTC+01:00) Brussels, Copenhagen, Madrid, Paris" )

Was this reply helpful? Yes No