Forum Discussion
How to split name of the file to store in another field in Document Library?
pexperzen If you are using SharePoint online, you can use Power automate flow to update the column in library based on file name.
You can configure your flow something like this:
ID and Name in second action are dynamic data from first trigger in flow.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
pexperzen Do you have this fixed file format? number_text OR number<space>text?
If yes, you can create a power automate flow (on file creation/update OR scheduled flow). In flow, split the file name based on _ or <space>, then update the another column using "Update file properties" action with the value you get from split operation.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.