Unanswered

Make a column auto update by Parent Folder Value

(0) Share

Report

Posted on by Atronin

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 hoping to using Flows, but when digging I cannot seem to find the value for that type of column, only columns in lists.

What is the best way for me to accomplish this?

All responses (7)

Answers (0)

jldodge 4 on at

Like (0)

Report

Re: Make a column auto update by Parent Folder Value

How would this work for a nested structure?

Is there a way to extract subfolder name to metadata too?
Community Power Pla... on at

Like (0)

Report

neRe: Make a column auto update by Parent Folder Value

Hello, This is really elegant. It worked for me.

Although I wondering if you would be able to help me with something.

I would like to make your automated flow a manually triggered flow (so that I don't have to modify the file).

Is there a way?

Cheers,

George
v-bacao-msft on at

Like (0)

Report

Re: Make a column auto update by Parent Folder Value

Hi @Atronin ,

Thank for your reply.

Please try to update the connection or recreate a similar Flow.

I did a test on my side. If there is a similar Column in the Library, these columns will be displayed in the Update file properties action.

Best Regards,
Atronin 4 on at

Like (0)

Report

Re: Make a column auto update by Parent Folder Value

@v-bacao-msft

Ok I reviewed your suggestion and I thnk this might work, however I do not see Title or section in my choices below. Can you help make them appear?
Atronin 4 on at

Like (0)

Report

Re: Make a column auto update by Parent Folder Value

@yashag2255

I am using the Section Column to show a metadata view by file, the folders do not require it.

I was trying this out but I do not get the same options you do in the last part of the flow
v-bacao-msft on at

Like (0)

Report
Re: Make a column auto update by Parent Folder Value

Hi @Atronin ,

Could you share a screenshot of the Flow configuration?

If you want to get Parent Folder Name, you could consider using the following method to get Parent Folder Name.

Expression reference:

split(triggerBody()?['{Path}'],'/')[sub(length(split(triggerBody()?['{Path}'],'/')),2)]

Image reference:

Hope it helps.

Best Regards,
yashag2255 24,503 Super User 2024 Season 1 on at

Like (0)

Report

Re: Make a column auto update by Parent Folder Value

HI @Atronin ,

Please refer to the screenshot below:

Just one thing, are you defining a section column on the folders too? What I mean is on what criteria of the folder are you trying to implement the section feature.

Hope This Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!