Error in convert time zone

[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

[v-yetonggu-msft · Accepted solution]

Hi @Wah22 ,

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

Best Regards,

Sunshine Gu

[Wah22]

Hi @v-yetonggu-msft , 

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

[v-yetonggu-msft]

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

[Wah22]

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

[v-yetonggu-msft]

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]

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]

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]

Hi @v-yetonggu-msft , 

Thanks. I am still getting error 😄

[v-yetonggu-msft · Accepted solution]

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]

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?

[v-yetonggu-msft]

Hi @Wah22 ,

I suggest you add another condition in the No area to determine whether the 'Review Date' is less than today's date.

Best Regards,

Sunshine Gu

[v-yetonggu-msft]

Hi @Wah22 ,

Correct my previous answer, if you want to check whether the date is overdue, then send an email, filter out the items whose 'ReviewDate' is not null in the 'Get items' control, and then add a condition to determine whether the date is less than today.

I did a test for your reference.

In my scenario:

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

Best Regards,

Sunshine Gu

[Wah22]

Hi @v-yetonggu-msft 

It works. Thanks a lot for your support. I am really appreciate it. 

[Wah22]

@v-yetonggu-msft 

I have another problem in another flow. I want to send the attachment from data verse which has been attached from canvas app. But the error was showed when I put the name and content at attachment section. I put the attachment name as Detail and dynamic content from dataverse. The error is as below. Any suggestion on this error? 

Best regards, 

Wah