cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Naoufal
Frequent Visitor

Transfer File from Sharepoint List to another Sharepoint List

Hello there,

 

I have a To-do List in Sharepoint and everytime when I set a To-do as "completed" I would like to transfer the whole file to another List which is the Archive for the To-Do`s.

 

it would be awsome to get some help from you guys.

 

Thx a lot

cheers, Joel

1 ACCEPTED SOLUTION

Accepted Solutions
Edd-Keogh
Helper III
Helper III

I would suggest it may be the wrong ID selected.

 

you want the second one wenn win element oder eine deter geandert wird

View solution in original post

12 REPLIES 12
Edd-Keogh
Helper III
Helper III

Hi Joel,

 

You would want to create a flow that actions on when an item or file is modified connect your site and select the list.

 

Next add a condition you would select your column from the dynamic content set is equal to and then match your choice of completed.

 

In the yes column you would then have create item this would be where your archive is and select your archive list. Populate each column with dynamic content matching you when an item is modified.

 

Finally to delete the original item you would select the original site and list and when selecting the ID ensure it is the ID for when an item or a file is modified and not create item.

 

EddKeogh_0-1668076457910.png

 

Hope this all helps 🙂

 

Thanks,

 

Edd

Naoufal
Frequent Visitor

Hey Ed,

 

 thx a lot for your response and your help.

Sadly I still don`t get it right still.

 

Naoufal_1-1668080253573.png

1. Ive made the described First Step form you.

For the File I chose the whole List.

There are some things which occure like attachments, but I dont know wether to take it or not.

 

2. After that I set the Status Value to "completed".

 

3. Here again im not sure what to pick for the File Name and the File Content.

Shall I use only the ID or take every point, like the title etc.

Naoufal_2-1668080376745.png

This is the List where I want to transfer the done task from to the second List ( To-do-archive)

 

Naoufal_3-1668080478224.png

 

Naoufal_4-1668080526015.png

Also can u maybe tell me where to get the ID from?

 

Thank you a lot for your help!

cheers, Joel

 

Hi Joel,

 

In your archive section it says folder path, you will need to select the list have you selected create file instead of create item? it will then list each column that is where you would enter the dynamic content individually for each one.

 

Thanks,

 

Edd

Edd-Keogh
Helper III
Helper III

Once you have the list it will look like this:

EddKeogh_0-1668081813834.png

It will be empty and you match the dynamic content.

Naoufal
Frequent Visitor

thx Ed you are right, ive changed it and set it to create Item ( In german it says Element )

Though I have to fill in some other Infos.

Naoufal_0-1668082682956.png

Like here I have to type in the Info I actually want to be tranfered.

Though it is like creating an Element.

 

Is it nevertheless right?

 

cheers

Joel

Edd-Keogh
Helper III
Helper III

You now go through and add your dynamic content:

 

EddKeogh_0-1668083106932.png

 

If its a choice column then you would select total value instead of total, if its just single line of text then just select total for instance.

Naoufal
Frequent Visitor

Thank you both for your help 😃

 

Now its working:

Naoufal_0-1668085849145.png

My last question I have is about the delete Item section.

Naoufal_2-1668085893253.png

I can choose now the ID. I am a bit afraid that it will not delete the right element.

Is this ID automaticaly connected to the element that was transfered?

So If I pick it that it will delete the right Element?

 

thx a lot

cheers Joel

 

 

Edd-Keogh
Helper III
Helper III

The ID you want is the original one. When an item is modified.

 

If that all works can you please accept as resolved and then it will stop it from showing as open 🙂

Naoufal
Frequent Visitor

Thank you a lot again!

Yeah I`ll do it.

 

But Still its not deleting the original file.

So ive set everything up:

Naoufal_0-1668086835618.png

But its still occuring in my List:

Naoufal_1-1668086868496.png

Naoufal_2-1668086981107.png

 

cheers

Joel

Edd-Keogh
Helper III
Helper III

I would suggest it may be the wrong ID selected.

 

you want the second one wenn win element oder eine deter geandert wird

Edd-Keogh
Helper III
Helper III

I would suggest it may be the wrong ID selected.

 

you want the second one wenn win element oder eine deter geandert wird

Naoufal
Frequent Visitor

Thx a lot ED. I will close now this topic and hope everything will work properly.

 

All the best 😃

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (6,175)