I am working with SP2019, on the file share there is a Legal folder added which gets lot of files dumped into it. Once users work on files, they save it there and send it to external party for review.
- For example a user could save a file named 'General Accounting Assessment'.
- The external party reviews it, then the file comes back named 'General Accounting Assessment_V1' and sits on the same shared folder as the original file.
This review process happens multiple times and that results into 4-5 files on the file share with below names: 1. 'General Accounting Assessment' 2. 'General Accounting Assessment_v1' 3. 'General Accounting Assessment_v3' 4. 'General Accounting Assessment_v4'
Users initially save a file 'General Accounting Assessment' to SharePoint prior to sending it out for review to external party so when v1, v2, v3 and v4 version files arrive, they manually rename the files to match it to name 'General Accounting Assessment' and drop into SharePoint so it can add up as a new version to the existing file.
I would like to automate this process and for which I am wondering if there is a way maybe by Flow or SharePoint to check whenever a new file is added, strip off the portion _v1 or _v2 or _v3 or _v4 dynamically appended at the end to file name 'General Accounting Assessment' and save it to SharePoint
Can someone please help on the proposed solution, thanks in advance.