Forum Discussion

Copper Contributor

Sep 06, 2021

Sharepoint Library Created and Modified Dates

Hello. I have a question about Files Created dates and retention Policies. If when i create my site y upload lots of files to a library at the same time, the file created date shows as the date ...

Document Library

SharePoint Online

Brass Contributor

Apr 19, 2022

I have the same issue - did you find a solution to this problem?

Thanks

Kelvin

SvenSieverding
Bronze Contributor
Oct 13, 2022
Kelvin_Kirby

You can use the rest endpoint

api/web/getfilebyserverrelativeurl('<absolute path to document>')/listitemallfields/ValidateUpdateListItem()

to update fields like "created" and "created by"

This works great from Power Automate
- claire2020
  Copper Contributor
  Oct 14, 2022
  SvenSieverding
  
  How can I apply this for updating the Created with another date field, i.e. Fieldname Created - Field Value WFCreated - my flow like this runs successfully but the outputs have an error message "
  "Enter a date and time like this: 23/02/2012 14:25" - I'm a novice at http, but I guess I need to convert the timezone, but have no idea how to do this?
  - SvenSieverding
    Bronze Contributor
    Oct 14, 2022
    It seems like the data from your WFCreated column is in another format than the rest endpoint expects...
    
    You should try to convert the value using one or more of the power automate expressions like
    
    formatDateTime(<Date>,'dd/MM/yyyy hh:mm')
    
    or with a timezone conversion
    
    convertTimeZone(<Date>,'UTC','Eastern Standard Time','dd/MM/yyyy hh:mm')
    
    What is the exact input in your "Send an HTTP Request to SharePoint" Action?

Share

Resources