Make a column auto update by Parent Folder Value

Question

I am setting up a new Document Library to organize several different types of Documents. I have a Folder View and a Metadata view. I am using a column named "Section" to sort the metadata view. I want to automate the Section column value based off of the parent folder name of the file.

I understand that this can be done in this way. But I want it to be dynamic and adjust to when new Folders and files are created to automatically change the "Section" column.

Currently the Section column is not tied to any lists, I created the column in the settings like this:

I am open to using Flows, but when digging I cannot seem to find the value for that type of column, only columns in lists.

Answer 1

You could use flow with a trigger "When a file is created or modified" Then take the link to item. then you could split this url and get the folder of the file.

Answer 2

You can use Document Set and a SharePoint Designer workflow to achieve it.

The steps for you:
1. Create a column called "Column1" and set it as a shared Column in Document Set
2. Create a workflow and design it like the below:

3. For Start Options, set it like: