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.