Unanswered

Moving files to 31 different folders in Sharepoint based on file name

(0) Share

Report

Posted on by nhollo

Hi everyone,

I built a flow to collect responses from forms pro, populate word template, convert them to pdf and save them in a folder in Sharepoint. The files are saved as "Applicant Name - City of applicant.pdf"

There are about 31 folders in my sharepoint library for each of these cities. I want to move these pdfs as they come along, to each of their folders based on the city of applicant in the file name.

I've tried a lot of things but nothing seems to work. I need your expertise!

I'd appreciate any help, thank you!

Categories:

Building flows

I have the same question (0)

All responses (14)

Answers (0)

ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

please @nhollo cloud you share an screanshot?

Was this reply helpful? Yes No
nhollo 12 on at

Like (0)

Report

Sure, this is what it looks like now:
The move file details were filled obviously 🙂

Was this reply helpful? Yes No
ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

its empty jejeje @nhollo

Was this reply helpful? Yes No
nhollo 12 on at

Like (0)

Report

it's not allowing me to post the photo!! I attach it and it keeps disappearing when I actually post the message.

Basically it is:

When a file is created
Condition: File Name contains "City Name"
If yes: Move file

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

If the files all have a '-' in the filename just before the city name, then I would do a split on '-' and then grab the first word of the second array index item. That will be the city name. Then you can run a Switch statement based on the value of the cityname and run the appropriate file move

Was this reply helpful? Yes No
nhollo 12 on at

Like (0)

Report

Thank you @Pstork1 . I will try that. Would you mind explaining how I could do the Switch?

Was this reply helpful? Yes No
nhollo 12 on at

Like (0)

Report

@Pstork1 It didn't seem to work..

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @nhollo

The below flow steps will give you a head start.

My library name is 'aj'

The expression I used to find the city name is as follows

trim(first(split(last(split(variables('Filename'), '-')),'.')))

My Test Result

Thanks

Was this reply helpful? Yes No
nhollo 12 on at

Like (0)

Report

@abm thank you for the reply. It fails when I try to move the file.

I'm a noob at variables.. so what i need to extract is "- CityName"

Will the trim function still be the same?

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @nhollo

Thanks for your reply

Declare another compose and add the below.

- Output('Compose)

Thanks

Was this reply helpful? Yes No