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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Datetime value changes...
Power Apps
Unanswered

Datetime value changes during a round-trip to a Dataverse entity.

(1) ShareShare
ReportReport
Posted on by molegris 157

Hi,

I'm implementing my own incremental dataflow and I came across an issue with the LastModifiedDateTime value.  The exact same value, from the exact same record gained 0.087 seconds during it’s round trip to Dataverse.  It’s not a big difference but it’s enough to return FALSE when comparing it to itself.

 

I fixed my problem with the workaround below but I’m worried I might eventually miss or double-count some records. 

 

Replace : [DateHeureDerniereMaj] = [getdate]

With : Number.Abs(Duration.Seconds([DateHeureDerniereMaj] - [getdate])) > 0.01

 

I still believe this is a BUG ! ... or is it something I'm doing wrong??

 

From the Dataflow editor :

datetimebugdataflow.png

 

From the Dataverse solution editor :

datetimebugdataverse.png

 

Thank you

--mo

Categories:
Building Power Apps
I have the same question (0)
  • poweractivate Profile Picture
    poweractivate 11,078 Most Valuable Professional on at

    @molegris 

     

    For now we are wondering though:

     

    Why are there two of the same kind of date fields in the Dataflow? Is one being populated in slightly different way from the other? Is one the out of the box column and the other a different kind of column? What do you mean specifically by 'round trip' exactly here?

     

    Other than the above questions to ask that may lead to why it is doing that, we're not sure, it may be expected behavior, maybe not - perhaps @v-bofeng-msft @v-xiaochen-msft @v-siky-msft or someone else have some more insight on this? We almost suggest that you might want to start support ticket except before doing that just yet, something here seems odd, especially that you have two dates there, one possibly being the out of the box one, this stands out. What happens if there are 3 of them - two are custom, and one the out of the box Last Modified - does this still happen anyway?

  • molegris Profile Picture
    molegris 157 on at

    Hi @poweractivate ,

     

    Non of those 2 dates are out the box ones.  Let me try to explain the process I use...

     

    There is a date column in the csv file I'm importing.  The name of that column is DateHeureDerniereMaj (which is french for LastModifiedDate) and it comes from an external source system.

     

    The csv file contains +25k rows so I want to avoid reloading all rows everytime we want to synch our Dataverse environment with the external system.  (p.s. I know the new Dataflow v2 offers incremental refresh but I don't want to use it at the moment)

     

    So after loading the +25k rows I extract the Max of DateHeureDerniereMaj and I store it in an entity I created to keep track of the last modified date for every imports.

     

    Then next time the Dataflow runs it filters the rows from the csv file to keep only the ones where DateHeureDerniereMaj column is greater then the Max(DateHeureDerniereMaj) that was stored the last time is ran.

     

    In this screenshot I'm comparing

    1. DateHeureDerniereMaj from the row in the csv file that has the max value for this column.
        I know from the csv file that this value is : "2020-12-09 05:47:10.087"

    with

    2. getdate value which is the Max(DateHeureDerniereMaj ) that was stored the last time the same csv file was imported.

     

    They should be equal because it's the same value from the same csv file.  But they are not equal anymore... somehow the ".087" second information was lost in the process.  But I don't know where and how.

     

    datetimebugdataflow.png

     

    --mo

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

News and Announcements

Welcome to the Power Platform Communities

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!

Congratulations to the February Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 549 Most Valuable Professional

#2
Kalathiya Profile Picture

Kalathiya 225 Super User 2026 Season 1

#3
Haque Profile Picture

Haque 224

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans