display value doesn't match get item

(0) Share

Report

Posted on by AC-21101901-0

Hi all,

Inside the flow I set condition to campare a data field WhenDeleteSite (D1) with following expression

formatDateTime(utcNow(),'yyyy-MM-dd')

In practice the condition is true when D1 is today. D1 is calculated field in a Sharepoint list

During the test I found a bizarre behaviour.

This is the scenario:

D1 = 31 August (see attachment)

Today = 31 August

but the condition is not satisfied.

Inside the flow an email is sent where the condition is not satisfied and I discovered the D1 value is not the same displayed. Here details:

1. WhenDeleteSite: 2023-08-30T22:00:00Z
2. WhenDeleteSite Formatted: 2023-08-30
3. Today: 2023-08-31T15:20:09.4898765Z

Note about above value:
1. Dynamic content
2. formatDateTime(first(outputs('Get_items')?['body']?['value'])?['WhenDeleteSite'],'yyyy-MM-dd')
3. utcNow()

So, display value doesn't match value by get items

Maybe timezone can determine the difference? ...other idea about difference?

Tks

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Sort by

dani135 32 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

I think the time zone may be a factor. Instead of formatDateTime(utcNow(), 'yyyy-MM-dd'), could you try formatDateTime(utcNow(), 'yyyy-MM-dd', 'Pacific Standard Time')

Was this reply helpful? Yes No
AC-21101901-0 on at

Like
a
(0)

Report
Copy link

Link copied!

Using timezone in formatDateTime an error is raised. So I used convertTimeZone in the condition

formatDateTime(convertTimeZone(items('Apply_to_each')?['WhenDeleteSite'], 'UTC', 'Romance Standard Time'),'yyyy-MM-dd')
equal to
formatDateTime(utcNow(),'yyyy-MM-dd')

Was this reply helpful? Yes No