I currently am setting up a Sharepoint library that has two managed metadata columns: one for project name, and one for document type. They both have keywords that come from a pre-made term set that is assigned to the metadata column. My current plan for the folder structure is to have all the projects be displayed, and then have a centralized system where all the projects have the same folders. For example, each project will have a folder for Testing, for Business, etc. These folders will be tagged with the appropriate keywords; if I have a project budget folder, it will be tagged with its project name and its document type.
My goal is to be able to drop a document into the document library, tag it with a keyword for the project name and document type metadata columns, and once I'm done tagging, then have it automatically move it into the folder that has the same metadata column values with a Power Automate flow. However, I'm having a bit of trouble, sometimes there are multiple subfolders within a subfolder; for example, I have a folder for Product Management, but within that folder there's another folder for Project Budgets, but the keyword associated with that folder is just project budget. This makes it a bit hard to just concatenate the keyword names together and move the file to that web address because it will be missing the Product Management component.
This might be a little confusing, so please reach out to me for any clarifications and I will try the best I can without breaking any company policies. I'm currently an intern, so I'm still figuring out some things. Thanks for the help!
