Update document column based on list items

(0) Share

Report

Posted on by Slumpig

I'm trying an failing to do this.

We have a document library with project folders with other folders and files inside. These root project folders correspond to a single List Item (Project list) which has client data etc etc in the columns. I'm looking to create a flow that gets the list item code (ProjectCode), goes to the library to find the first 4 characters of the root folder which is the ProjectCode, goes into that folder and puts the client name from the list item into the client column for the documents....then moves onto the next project code in the list.

I know there is a wider metadata conversation here but we have many projects and adding all of them into the Term store without a way to do that easily isn't really an option.

Any help appreciated as always.