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?

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report
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,

Was this reply helpful? Yes No
Atronin 4 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
Atronin 4 on at

Like (0)

Report

@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?

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report

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,

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
jldodge 4 on at

Like (0)

Report

How would this work for a nested structure?

Is there a way to extract subfolder name to metadata too?

Was this reply helpful? Yes No