cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TorreyFalconer
Level: Powered On

Update property based on folder name

Hey PA Community!

 

I need some input on how to build a flow. I have a SharePoint document library that contains folders for each "case". So a folder that reads "Case-1", "Case-2" etc. 

Inside those Case folders are images and documents that all individually contain the property "Case ID" as well, so if they are ever in a different view you can still sort them by the Case ID property.

Now, the issue is that when people sync this document library to their desktop and drop images and files into the Case folders, that Case ID property doesn't get updated on the individual file. I am hoping to automate this process. 

So basically I need to create a flow that will identify an image or file that has the missing Case ID property and update it based on the folder name (as the folder name would be "Case ID-"#") 

 

Help with building this flow would be greatly appreciated!

-T

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Update property based on folder name

Hi @TorreyFalconer this is exactly what Document Sets in SharePoint are for, i recommend you create a Document set and replace your folders with document sets, the usage will be very similar for the users, but it will allow you to share columns and therefore automatically populate metadata with the case id. It will be much simpler and more reliable than constructing/monitoring a flow. 

 

https://support.office.com/en-us/article/create-and-configure-a-new-document-set-content-type-9db6d6...

View solution in original post

1 REPLY 1
Super User
Super User

Re: Update property based on folder name

Hi @TorreyFalconer this is exactly what Document Sets in SharePoint are for, i recommend you create a Document set and replace your folders with document sets, the usage will be very similar for the users, but it will allow you to share columns and therefore automatically populate metadata with the case id. It will be much simpler and more reliable than constructing/monitoring a flow. 

 

https://support.office.com/en-us/article/create-and-configure-a-new-document-set-content-type-9db6d6...

View solution in original post

Helpful resources

Announcements
firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors
Users online (5,490)