Moving Files to Folders Listed in Excel

(0) Share

Report

Posted on by MG_Prime

Hi everyone

I have a table with 2 columns: File_name & Folder_location. The table consist of two rows:

"AAA" | "my_SharePoint/.../AAA"

"BBB" | "my_SharePoint/.../BBB"

...

"ZZZ" | "my_SharePoint/.../ZZZ"

Then I have a SharePoint folder (folder_X) which contain

files with name such as AAA_20221010, AAA_20221009, BBB_20221010, and so on.

Is it possible to create a flow to automate moving files from folder_X to folders listed in the second column based on the file's name? (Triggered whenever a new file is created in folder_X)

Thanks in advance

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Sundeep_Malik 6,484 on at

Like (1)

Report

Re: Moving Files to Folders Listed in Excel

Hey @MG_Prime
This is possible in power automate, but go ahead carefully and step by step. Below is the flow:

Expression: split(outputs('Get_file_metadata')?['body/Name'],'_')?[0]

Split function converts string to an array. So the name of the file AAA_22, will now split into AAA and 22. So used 0 at the end to grab just AAA from there.

After this you can use list rows in a table and in filter query give columnname eq 'Outputs of above compose'

But make sure there is no space between the column name, filter query does not work if there is space between column name. If you have a space and can rename it, it will be better.

Or if you dont want to use filter query, then in the next step you can add a condition action and match the column to output of above compose.

And then in if yes just give the file destination from the second column.

Was this reply helpful? Yes No
MG_Prime 33 on at

Like (1)

Report

Re: Moving Files to Folders Listed in Excel

it works like a charm. lesson learned.

thanks a lot, Mr Malik

have a good day
🙂

Was this reply helpful? Yes No