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 the file was loaded - if there is a Retention policy applied that is to keep the file (for exmaple) 5 years, if i cannot modify the Created field on the library to show the correct date, how will the policy work correctly then?is there a way to change the Created Date (without having to ad a new column for every library) thank you

MVC_User Hi,Is there a legal requirement to use the created date and not the modified date?You may want to consider using tools that retain the original create/modify date.Paul | SLIM Applications

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 Writing column name directly like this will not work. Try configuring your flow as given below: Use body like: { "formValues": [ { "FieldName": "Created", "FieldValue": "@{formatDateTime(item()['WFCreated'], 'dd/MM/yyyy HH:MM')}" } ], "bNewDocumentUpdate": true } Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Where exactly in the world are you?Your date is most likely not in the correct zimezone format. so try this formula@{convertTimeZone(item()['WFCreated'],'<Your Time Zone>','UTC','dd/MM/yyyy HH:MM')}<Your time zone> is your local time zone....I use "W. Europe Standard Time" as a value for my timezone, you can get yours from https://www.ge.com/digital/documentation/meridium/V36160/Help/Master/Subsystems/AssetPortal/Content/Time_Zone_Mappings.htm(from the column "Standard Time Zone Name")If that does not work, then also try switching the timezone parameters:@{convertTimeZone(item()['WFCreated'],'UTC','<Your Time Zone>','dd/MM/yyyy HH:MM')}

claire2020 Try using convertToUtc or convertTimeZone function instead of "formatDateTime" function in body.Please consider giving a Like if my post helped you in any way.

Sharepoint Library Created and Modified Dates

Paul_HK_de_Jong
Iron Contributor
Sep 06, 2021
MVC_User
Hi,
Is there a legal requirement to use the created date and not the modified date?
You may want to consider using tools that retain the original create/modify date.

Paul | SLIM Applications
Kelvin_Kirby
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?

Forum Discussion

Sharepoint Library Created and Modified Dates

Share

Resources