
(Reposting to correct forum)
Hi, I had a simple flow created which is triggered whenever my file properties changes. When this occurs, the flow copies the file and file property data to another SharePoint site. All of the metadata properly copies over (including the file) with the exception of a date field "Eff Date" which comes over one day behind. I am baffled as to why this is occurring.
In this example, I selected edit in grid view and changed "Eff Rev" to 33 and "Eff Date" to "12/31/2023".
The SharePoint which is updated shows this result (note the date):
Here is the flow:
I have never had a problem when using Update File Properties. Do these actions work differently in flows using Get File Metadata?
Thanks!
Hi @JT-1964,
I would suggest to check the time zone in the regional settings of both sites?
If the sites are in different time zones it is perfectly possible that the source date time 12/31/2023 00:00 (for example London time zone) could be a different date time in another time zone (like for example Seattle time zone), that can even be the day before.