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?
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!
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.
Hope it helps.
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
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?
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.
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?
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!