How to Automatically Add Created Date to SharePoint Document Set Names
Question details
The user wants to automatically append the creation date and time to a SharePoint Document Set name while maintaining the contact name in a separate column.
- Product
- SharePoint
- Device & OS
- not provided
- Scenario
- Creating new Document Sets in a SharePoint library and standardizing the naming convention automatically.
- Observed behavior
- SharePoint JSON formatting does not reliably populate the document set name using the 'Created' metadata during the initial form submission.
Before starting, ensure you have sufficient permissions to create Power Automate flows in your Microsoft 365 environment and that your target library has the Document Set content type enabled.
Use Power Automate to Update the Document Set Name
Since JSON column formatting cannot dynamically pull the 'Created' metadata during the initial form submission for a Document Set name, configuring a Power Automate flow is the most reliable method.
SharePoint calculates the 'Created' date only after the item is saved to the server, meaning JSON formatting in the creation form cannot access this data instantly. Power Automate solves this by running a background process immediately after the Document Set is generated.
Navigate to Power Automate, click on 'Create' in the left menu, and select 'Automated cloud flow'.
Name your flow and search for the trigger 'When a file is created (properties only)'. Select it, click Create, and connect it to your specific SharePoint Site Address and Library Name.
Click 'New step' and add a 'Condition' control. Set the condition to check if the 'Content Type' is equal to your specific Document Set content type name to ensure regular files or folders are ignored.
Under the 'If yes' branch, add the 'Update file properties' action. Select your Site and Library again, and map the 'Id' field to the ID from your trigger step.
In the 'Title' or 'Name' field, use the dynamic content menu to add an expression. Type `formatDateTime(triggerOutputs()?['body/Created'], 'yyyy-MM-dd')` to format the date, and concatenate it with your desired text or original Document Set name.
Click 'Save' at the top right. Go to your SharePoint library, create a new Document Set, and wait a few moments to verify the flow automatically appends the date to the name.
Looking for a Faster Way to Manage Office Documents?
While configuring complex SharePoint automated flows can be time-consuming, creating and editing the documents inside them doesn't have to be. WPS Office offers a free, lightweight, and highly compatible alternative to Microsoft Office for all your local and cloud document needs.
- 1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
- 2. Install and Launch: Run the installer, follow the on-screen prompts, and open the WPS Office application.
- 3. Open Your Documents: Seamlessly open your existing Word, Excel, and PowerPoint files without losing formatting or layouts.

Frequently Asked Questions
Why doesn't JSON formatting work for naming new SharePoint Document Sets?
JSON formatting customizes how existing data is displayed but cannot pull system-generated metadata like the 'Created' timestamp before the item is actually saved to the SharePoint server during the initial form submission.
Can I format the date specifically for the Document Set name in Power Automate?
Yes. When building your Power Automate flow, you can use the 'formatDateTime' expression to format the date exactly as you need it, such as 'MM-dd-yyyy' or 'yyyyMMdd_HHmm'.
Will this flow accidentally rename standard folders or files in the library?
It will if you don't filter them out. You should always add a condition step in your flow to only run the 'Update file properties' action when the item's Content Type equals your specific Document Set content type.
How do I keep the contact name separate from the Document Set name?
You can create a separate custom column in your SharePoint library for the contact name. The Power Automate flow can then read this column during automation while exclusively appending the created date to the primary Document Set name.




