cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
frixel
Level: Powered On

Copy data from Onedrive to Sharepoint file

Hi all,

 

Is it possible to do the following with Flow?
Copy the data from a file on Onedrive (for Business) to a file on Sharepoint on the next empty line.

 

Something like the one below but I am aware that it is not that simple.

 

17-9-2019 9-25-09.png

21 REPLIES 21
Community Support Team
Community Support Team

Re: Copy data from Onedrive to Sharepoint file

Hi @frixel,

 

You could do it with a more simple way, you could following these steps:

Annotation 2019-09-18 130433.png

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

frixel
Level: Powered On

Re: Copy data from Onedrive to Sharepoint file

@v-litu-msft 

 

Thanks i have make the Flow as sugested but then i have a error.

It seems the file is be locked.

The file and the flow is made in the same account, what must i do?

 

 

flow1.png

Community Support Team
Community Support Team

Re: Copy data from Onedrive to Sharepoint file

Hi @frixel,

 

The file is encrypted, so the file could not be copied by the Flow, if you want to do it, you need to decrypt it.Annotation 2019-09-18 142956.png

 

Annotation 2019-09-18 143022.png

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

frixel
Level: Powered On

Re: Copy data from Onedrive to Sharepoint file

Hi @v-litu-msft 

 

When i look at the attributes from the original file in OneDrive i see not it is decrypted.

 

flow2.png

Highlighted
frixel
Level: Powered On

Re: Copy data from Onedrive to Sharepoint file

I don`t know how i can see the properties from the sharepoint file for to see that one is dedrypt.

Community Support Team
Community Support Team

Re: Copy data from Onedrive to Sharepoint file

Hi @frixel,

Maybe this document about SharePoint file permission will help you:

https://support.office.com/en-us/article/customize-permissions-for-a-sharepoint-list-or-library-02d7...

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

frixel
Level: Powered On

Re: Copy data from Onedrive to Sharepoint file

Oke, i see now that the sharepoint file must not be open.

Only when it is close ther is a update?

frixel
Level: Powered On

Re: Copy data from Onedrive to Sharepoint file

Hi @v-litu-msft 

 

Great, i have this working but i want that new data(when a new file is in Onedrive with same name and format) it copy to the sharepoint file but under the other data.

Is that also possible?

Community Support Team
Community Support Team

Re: Copy data from Onedrive to Sharepoint file

Hi @frixel,

 

I don't understand the meaning of new data, is it the update file content of the file in the OneDrive or a copied file content?

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

frixel
Level: Powered On

Re: Copy data from Onedrive to Sharepoint file

hi @v-litu-msft 

 

Yes, it is the file in onedrive. there is every day a new document with the same name.

I want that the new data from the new file in onedrive to the sharepoint file goes but then under the data there already exist .)from the past data)

 

I hope you so understand what i mean. (sorry for my bad english)

Community Support Team
Community Support Team

Re: Copy data from Onedrive to Sharepoint file

Hi @frixel,

 

Never mind, I just want to make sure of your requirements. So, the step is when the file in OneDrive update copy the file to SharePoint with a new name if there has already existed one.

 

I think this method would help you:

Step 1. Create a trigger When a file is modified.

Step 2. Create the file in a subfolder (named temp, just for store the file temporarily) in the SharePoint Library.

Step 3. Add Get file properties action to get the file's Identifier.

Step 4. Copy the newly created file into your destination folder with the option if another file is already here copy with a new name.

Step 5. Delete the newly created file in the temp folder.

Annotation 2019-09-20 094606.png

 

Annotation 2019-09-20 094649.png

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

frixel
Level: Powered On

Re: Copy data from Onedrive to Sharepoint file

Hi @v-litu-msft 

 

I think you don`t understand it.

Not copy the onedrive file to sharepoint bust only the information in that onedrive file.

 

The senario is: When there is in the onedrive a new file (it has alway`s the same name and headers) it mus this information put in the sharepoint file under the information there still is in the sharepoint file. 

 

 

Community Support Team
Community Support Team

Re: Copy data from Onedrive to Sharepoint file

Hi @frixel,

 

Do you mean to add the information into the SharePoint file if new data added in the OneDrive?

Such as,

SharePoint file Content:

record 1

record 2

When the file in the OneDrive data update with record 3, add it into the SharePoint file:

 

SharePoint file Content:

record 1

record 2

record 3

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

frixel
Level: Powered On

Re: Copy data from Onedrive to Sharepoint file

Hi @v-litu-msft 

 

Like that but record 3 is the next day in a new file on onedrive.

 

And this is than correct;

SharePoint file Content:

record 1

record 2

record 3

 

Community Support Team
Community Support Team

Re: Copy data from Onedrive to Sharepoint file

Hi @frixel,

 

If when update the file would not delete the original file, and the Excel file is fixed, maybe you could use the method:Annotation 2019-09-20 175149.png

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

frixel2
Level: Powered On

Re: Copy data from Onedrive to Sharepoint file

 
frixel
Level: Powered On

Re: Copy data from Onedrive to Sharepoint file

Hi @v-litu-msft 

 

I have a problem with the table in the onedrive file.

This file is a export from a program and save it to the onedrive and therefore it has no table.

 

flow1.png

Community Support Team
Community Support Team

Re: Copy data from Onedrive to Sharepoint file

Hi @frixel,

 

Please save the Flow and Excel file, close the Excel file and Flow, then open the flow and try again.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

frixel
Level: Powered On

Re: Copy data from Onedrive to Sharepoint file

Hi @v-litu-msft 

 

then i have this error

 

flow2.png

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 250 members 6,555 guests
Please welcome our newest community members: