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.
Thank you Don Kirkham for your kindly.
I do follow your suggestion but the output is 0. ( in filename_ma)
I have no idea what's my mistake. T^T
1. Use Power Automate to populate the filename_ma column when a new document is added.
2. Use Power Automate to copy the filename into the Title column, then have filename_ma be a calculated column using Title (instead of Name)
Good luck!
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.