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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Error in convert time ...
Power Automate
Unanswered

Error in convert time zone

(0) ShareShare
ReportReport
Posted on by 69

Hello, 

 

I am new to automate flow and having an issue in running automate flow for sending reminder email to document owner in share point folders. My flow is as below screenshot. 

 

Wah22_0-1703089119791.png

 

The date format in share point folder is DD/MM/yyyy.

Wah22_1-1703089155031.png

 

The test run successfully but I haven't received an email to take an action in share point. 

 

Thanks in advance for your support. 

 

Best regards,

Wah

Categories:
I have the same question (0)
  • Verified answer
    v-yetonggu-msft Profile Picture
    on at

    Hi @Wah22 ,

    Please check the output time format of this control in the historical running records.

    vyetonggumsft_2-1703122614464.png

     

    Best Regards,

    Sunshine Gu

     

     

     

  • Wah22 Profile Picture
    69 on at

    Hi @v-yetonggu-msft , 

     

    It is formatdatetime(utc(),'yyyy-MM-dd')

  • v-yetonggu-msft Profile Picture
    on at

    Hi @Wah22 ,

    The time formats on both sides of the condition do not match.

    Nest the 'Review' dynamic content on the left into this format.

    vyetonggumsft_1-1703166380879.png

    formatDateTime('Dynamic Content','yyyy-MM-dd')

    Best Regards,

    Sunshine Gu

  • Wah22 Profile Picture
    69 on at

    Hi @v-yetonggu-msft , 

     

    Thanks for your input. I tried with your solution and it is still getting error. 

    Wah22_1-1703167238493.png

    formatDateTime('Review Date','yyyy-MM-dd')
     
    Thanks. 
    Best regards, 
    Wah
  • v-yetonggu-msft Profile Picture
    on at

    Hi @Wah22 ,

    Maybe your understanding is a little different. Put the dynamic content in instead of putting the control name in the formula.

     

    Best Regards,

    Sunshine Gu

  • Wah22 Profile Picture
    69 on at

    Hi @v-yetonggu-msft , 

     

    It may be. Review Date is my dynamic content. I put it on the left side of condition statement in expression formula bar. 

  • v-yetonggu-msft Profile Picture
    on at

    Hi @Wah22 ,

    Yes, please put this expression on the left side of condition.

     

    formatDateTime(items('Apply_to_each')?['ReviewDate'],'yyyy-MM-dd')

     

    Best Regards,

    Sunshine Gu

  • Wah22 Profile Picture
    69 on at

    Hi @v-yetonggu-msft , 

     

    Thanks. I am still getting error 😄

    Wah22_0-1703168787399.png

     

  • Verified answer
    v-yetonggu-msft Profile Picture
    on at

    Hi @Wah22 ,

    Try again:

    if(empty(items('Apply_to_each')?['ReviewDate']),null,formatDateTime(items('Apply_to_each')?['ReviewDate'],'yyyy-MM-dd'))

    Best Regards,

    Sunshine Gu

  • Wah22 Profile Picture
    69 on at

    Hi @v-yetonggu-msft , 

     

    Thanks a million. It works with my current requirement. But when I changed the condition of reviewdate is less than or equal to , I am still getting error. Can you recommend what if I want to get notification email for the documents which are overdue review date as well?

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 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard