cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ArneVTR
Regular Visitor

2 way syncing a map in Onedrive with a map in Sharepoint

Hello

 

I am making an app with PowerApps to edit some Excel files more easily. The problem is that PowerApps can only edit Excel files that are saved in OneDrive, not ones that are on Sharepoint sites. I can work around this by copying the files from Sharepoint to Onedrive but the files that are left on Sharepoint should be synced with the ones that are in Onedrive and the other way around. That way we could edit a file in Onedrive or in Sharepoint and it would update on both platforms.

 

I want to make a flow for this but I can't seem to find a good solution. I can make a flow that updates the other folder, but only one way. If I make two flows (one for auto syncing Onedrive to Sharepoint and one for auto syncing Sharepoint to Onedrive), I create an infinte loop because they get triggered by eachother and not just by a user editing a file...

 

I hope that there is a solution for this.

 

Kind regards
Arne

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @ArneVTR, rather than both of your Flows being automated, have you tried switching the one which syncs from ODFB to SharePoint to be a PowerApps trigger? That way, you can add the Flow trigger into your PowerApp, therefore you won't have an infinite loop. 

View solution in original post

5 REPLIES 5

Hi @ArneVTR, rather than both of your Flows being automated, have you tried switching the one which syncs from ODFB to SharePoint to be a PowerApps trigger? That way, you can add the Flow trigger into your PowerApp, therefore you won't have an infinite loop. 

Thank you @MattWeston365! I didn't think about that yet. 

pedronac
New Member

Hello, 

 

I'm very new on Power Automate and more a marketing guy...

But I need to copy the documents of SharePoint over an OneDrive account.
This way it will possible to make automatics backup using a Synology NAS. 

 

I tryed to do a Flow, but it does not work.

Could someone please share a flow that copies files from SharePoint to OneDrive?

 

There is a similar post about https://powerusers.microsoft.com/t5/Building-Flows/Syncing-files-and-folders-from-Sharepoint-documen...

But no solution pour instance.

 

Thanks,

Pedro

 

Hi Arne, 

I've got the message bellow on my notification, but I can not find the flow ; 

 

Hi pedronac,

ArneVTR (Level: Powered On) posted a new reply in Building Flows on 12-12-2019 05:11 AM:


Re: 2 way syncing a map in Onedrive with a map in Sharepoint

Below I've added my flow to sync Sharepoint to OneDrive. This copies a file from Sharepoint to OneDrive everytime a file in a specified folder is edited or made. It is in Dutch but I hope it helps!

 

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (3,402)