Flow to create new folders from list in Excel and then copy in files from another folder

[PipManifold]

Hi there.

I have a list of programs for which I need to create a folder for and then copy the corresponding Excel file from the folder they are saved in into the newly created folder.

Here is my test list of programs:

Here is what the folder with the excel files in them looks like, they all have the same name except for the program code:

This is what I have done so far, however, the create folder part is working great, however, when it gets to the copy file section, it doesn’t like how I’m using the dynamic content and says it can’t identify a file.

Error message

Failed to verify the existence of source object at 'https://xxxxxxxxxxxxxx/sites/DSCQualityEnhancement/Shared Documents/CES_SES_GOS/CES/Program Course Mean Summaries/CES Program Course Mean 2020 S2/CES Program Mean Summary (HE) 310P-MC193 (Semester 2, 2020).xls' due to error 'The system cannot find the file specified. (Exception from HRESULT: 0x80070002)'.

clientRequestId: 3a13444c-77be-496f-8ced-8889a013dd8a

[v-duann-msft · Accepted solution]

Hi @PipManifold 

Thank you for posting.

According to your description, you would like to create folder based on file code and then move file to according folder. But currently got verification error.

If that’s the case, I believe the issue is caused by folder path format. The Identifier of the file should encode to URL format, so you should replace these "/" to "%2F". So you could use the replace() function to process the file path, for example:

Once tested, I can copy file successfully.

Hope the content above may help you.

Best regards,

Anna

[PipManifold]

Hi @v-duann-msft 

Thanks for your help with this.  Unfortunately I've implemented this and there is no luck on my end.  I still get the unable to match error

[PipManifold]

Thanks so much @v-duann-msft .  Did some more playing and discovered it was the spaces not the /s which it was having issues with. Replaced all those with %2b and seems to have done the trick 🙂

Thanks for all your help

[v-duann-msft]

Hi @PipManifold 

Thank you for your attempts.

It looks like you input incorrect expression in the last action. It's '%2F' instead of '%F2'. Please help me to modify it.

replace(outputs('Compose_2'),'/','%2F')

replace(outputs('Compose_3'),'/','%2F')

I have already checked other settings, seems it's all good except that expression.

Hope it helps

Best regards,

Anna

[v-duann-msft]

Hi @PipManifold 

Glad to hear you found the small mistake.

Have a great day!  😀

Best regards,

Anna