Good morning,
I have files in folder-A that are named after the items in a sharepoint list and I need to copy them into folder-B, adding to filename the category taken from the list, please see example below:
in folder-A the system create file "Item 1", when the file is created, I would like it to be copied to folder-B and saved as "Item 1 Cat-A" (the process to create the file in folder A is already in place, just need to know how to make the copy and rename)
| My sharepoint List |
| Title | Category |
| Item 1 | Cat-A |
| Item 2 | Cat-B |
| Item 3 | Cat-A |
| Item 4 | Cat-C |
| Item 5 | Cat-A |
Note: I can set up the flow "when a file is created then copy to" but i miss the step in between to get the category into filename.
