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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Sharepoint to Google C...
Power Automate
Unanswered

Sharepoint to Google Calendar issues with Min Time

(0) ShareShare
ReportReport
Posted on by 9

I created a flow that post a modifies from SharePoint to a corresponding  (newly created) Google calendar's, everything worked perfect first 5 days. I was able to narrow down the problem to “list the events on a calendar” min time (does not like searching 1,000's of events). I manually entered todays date (not searching past posting) all is good.  I want to have todays date and time format under min time, I have tried Now(), Today()..flow fails, it must have time format. Thanks for any help.

 

flow.GIF

Categories:
I have the same question (0)
  • v-yamao-msft Profile Picture
    Microsoft Employee on at

    Hi @robbcmv,

     

    We could use function utcnow to get today’s date in Flow.

    The following doc on DateTime functions could be your reference:

    https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#date-and-time-functions

    In addition, we also need to use formatDateTime function to format the date time to the required format “yyyy-MM-ddTHH:mm:ss.000Z”

    I have made the following flow for your reference.

    Input the following code in Min Time field to get the current date:

    utcNow('yyyy-MM-ddT00:00:00.000Z')

     

    Enter this formula in the Max time field:

    formatDateTime(addDays(utcNow(),30),'yyyy-MM-ddT00:00:00.000Z')

     

     A screenshot for your reference:

    1.PNG

     

     

    Best regards,

    Mabel

  • GabrielStJohn Profile Picture
    Microsoft Employee on at

    Hello, @robbcmv!

    Thank you for posting on the Flow Community Forum! Have you had an opportunity to apply @v-yamao-msft‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!

    Thank you for being an active member of the Flow Community!

    -Gabriel
    Flow Community Manager

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 283

#2
David_MA Profile Picture

David_MA 256 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard