Good day!
I have a flow that pulls the attachments and copies them to a SharePoint document folder when a new item is created on a SharePoint list. This works great, but I need to add a feature. I have eight files that users can already download and use to attach to the list. Eight folders in the document library correspond with each of the eight files. At times, when attaching a file to the SP list, it renames the file by adding numbers to the end (or the user might rename the file slightly.)
I want to check the file name on the SP list and move it to the correct folder for easy retrieval. For example, we have "Confined Space Documents.pdf" and "Incident Report Form.pdf" that we want to go into the "Confined Space Documents" or "Incident Report Form" folder with the username and date as the filename. My current process creates a new folder depending on the file name. Still, we want the "Confined Spaces Documents" files to go into the "Confined Spaces Documents" folder, no matter if the file is named "Confined Spaces Documents (1).pdf" or "Confined Spaces Documents 2001502.pdf."
Any ideas to make this happen efficiently?


Report
All responses (
Answers (