web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Power Automate Problem...
Power Automate
Unanswered

Power Automate Problem with Sharepoint List DateTime creating Outlook Calendar entries

(0) ShareShare
ReportReport
Posted on by 4

I have a PowerApps front-end which creates entries in a SP list.  Once a record is added a Flow take details including start and end date/time and creates an Outlook Calendar entry using Create Event (V4).  Although I believe I have the date/times in UTC format in SP I get an error in flow that prevents me from saving.  The error is: 

 

Flow save failed with code 'OpenApiOperationParameterValidationFailed' and message 'Input parameter 'item' validation failed in workflow operation 'Create_event_(V4)': The parameter with value '"@outputs('Get_item')?['body/VisitStart']"' in path 'item/start' with type/format 'String/date-time' is not convertible to type/format 'String/date-no-tz'.'.

 

So I have tried using the Flow function Covert Time Zone but it now adds 1 hour on so that the calendar entry is wrong.  Here is the convert formula:

 

ChrisLloyd_100_2-1666630318702.png

 

 

I'm going round in circles!!

Categories:
I have the same question (0)
  • ChrisLloyd_100 Profile Picture
    4 on at
    Re: Power Automate Problem with Sharepoint List DateTime creating Outlook Calendar entries

    I've kind of solved this myself by changing the destination time zone from GMT to UTC in the conversion.  So convert is taking a UTC date/time input and outputting the same thing.  I still don't understand why the convert function recognises my date as UTC but Create Event (V4) doesn't.

     

    ChrisLloyd_100_0-1666631018787.png

     

     

  • Verified answer
    v-chengfen-msft Profile Picture
    on at
    Re: Power Automate Problem with Sharepoint List DateTime creating Outlook Calendar entries

    Hi @ChrisLloyd_100 ,

    Do you want the [start time] of SharePoint list to be the same as the Outlook calendar events [start time]?

    If yes,

    Here is a test for your reference:

    Note : Make the time zone of sharePoint the same as the time zone of outlook calendar

    Please follow the steps to modify the time zone in Share Point :

    vchengfenmsft_0-1666777769900.png

     

     

    Please follow the steps to modify the time zone in Outlook Calendar:

     

    vchengfenmsft_1-1666777769925.png

     

    Here is flow:

    vchengfenmsft_2-1666777769929.png

     

     

    Here is result:

    vchengfenmsft_3-1666777769932.png

     

    Best Regards

    Cheng Feng

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard