Answered

Error in convert time zone

(0) Share

Report

Posted on by Wah22

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.

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

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:

Building flows

I have the same question (0)

All responses (14)

Answers (2)

Verified answer

v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Wah22 ,
Please check the output time format of this control in the historical running records.

Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
Wah22 69 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-yetonggu-msft ,

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

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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.
formatDateTime('Dynamic Content','yyyy-MM-dd'）
Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
Wah22 69 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-yetonggu-msft ,

Thanks for your input. I tried with your solution and it is still getting error.
formatDateTime('Review Date','yyyy-MM-dd')

Thanks.
Best regards,
Wah

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Wah22 69 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
Wah22 69 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-yetonggu-msft ,

Thanks. I am still getting error 😄

Was this reply helpful? Yes No
Verified answer

v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
Wah22 69 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No