Answered

Move file in SharePoint to a folder based on the Modified By

(0) Share

Report

Posted on by Zainab J

Hello,

I'm trying to create a flow that move files from one SharePoint to another based on the Modified By column. I need the flow take the modifier name and loop through the existing folders, if there is a folder that matches the modifier's name; move the file to that folder. If not, create a folder for the new modifier's name and move the file to there.

I created a condition that specify the known users whom usually create those files (Check attached image), but I want the flow to loop through the names and folder instead of specifically given names

Thank you in advance

Categories:

Using flows

Move file flow.PNG

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

v-mengmli-msft on at

Like (1)

Report
Hi @ZainabJ ,

Please try this:

Overview:
test1 folder stores multiple folders named with person name.
test2 folder stores files created by user.

1.get new file properties in test2 folder.

2.list folders in test1.

3.filter folders in test1 which has same name with "Modified By DisplayName" dynamic content about "when a file is created".

The details in Condition:
1.Determine whether the filter result in the above steps is empty, if it is empty, create a new folder.

2.Compose: get the folder path which is used to store the new file with same person name.

Expression in Condition:
empty(body('Filter_array'))
Expression in Compose:

outputs('Filter_array')?['body'][0]['Path']

Thanks for reading!
Rimmon

Was this reply helpful? Yes No
Zainab J 18 on at

Like (0)

Report

Thanks Rimmon for the quick response and thorough explanation
I will give it a try and see if it works

Regards,
Zainab

Was this reply helpful? Yes No
Zainab J 18 on at

Like (0)

Report

Hi @v-mengmli-msft,

All the steps works fine but not the final "Move file". It throws an error

Appreciate the help

Was this reply helpful? Yes No
v-mengmli-msft on at

Like (0)

Report

Hi @ZainabJ ,

The error shows the destination is a pdf file not a folder.
Please check the destination in the move file, it should be a folder path which is used to save files.

Best regards,
Rimmon

Was this reply helpful? Yes No
Zainab J 18 on at

Like (0)

Report

Thanks @v-mengmli-msft
It turned out I chose the wrong identifier. It is working fine now

Many thanks

Was this reply helpful? Yes No