I am trying to figure out how to set a flow that when I update a file in Dropbox, it automatically updates the file in Sharepoint. I have successfully set up the basic flow to get a file from DB to Sharepoint...but this updating thing has me stumped.
I'm just going for a basic scenario that assumes that the file location hasn't changed for either file.
Could you please share the errors in your flow, so that we could take a further investigation?
I would say I also stucked at the file path part. But got this one working.
See the details from my testing:
Based on what I have tested, when selecting the DropBox available function "When a file is modified", it will only accept a file path, so if we would just want to update one file, then please specify a special folder for the file in DropBox, after that, we could click on the folder icon, and navigate to the proper folder;
After that, click to add an action, choose SharePoint "Update File", enter the site URL in the "site URL" box, then under the File identifier, click on the folder icon and navigate to the File that you would like to update (Well, I have wrongly choose the File path from the auto-generated content in DropBox, which won't work),
After that, under the File content, we could choose the File Content, click save.
Please test this one and see if it would work for you. Or if you need any further assistance regarding file update, please feel free to post back.
By the way, there are templates available to Copy the file between DropBox and SharePoint,vice versa, see:
Hi Michael -
I was able to get it to update a single file as you were, but what I want it to do is overwrite the file on Sharepoint if I save a new version on Dropbox, without building a unique flow for each file.
The issue is I am the only one in my company using a Mac, and we have begun moving all our files from Dropbox to Sharepoint. Unfortunately, it is currently impossible for Macs to map to a shared, cloud-based Sharepoint site (or, if it is possible, we haven't found anyone who can tell us how to do it)
The hope was to use this flow as a work around so that I could automatically drop things in Sharepoint (from Dropbox) and save over them as I was working on them, instead of having to save locally, open up the web version, save it there, and then delete the local file every time.
For the record though, these are the steps I went through in building my flow:
Again, the goal was that when any file in that Dropbox file was modified, the corresponding file in Sharepoint would be updated. This is the error I got:
It's easier just to cut and paste the error message in the "Body Portion":
Server Error in '/' Application.
Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed.
Details: To enable the details of this specific error message to be viewable on the local server machine, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "RemoteOnly". To enable the details to be viewable on remote machines, please set "mode" to "Off".
<!-- Web.Config Configuration File --> <configuration> <system.web> <customErrors mode="RemoteOnly"/> </system.web> </configuration>
Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.
<!-- Web.Config Configuration File --> <configuration> <system.web> <customErrors mode="On" defaultRedirect="mycustompage.htm"/> </system.web> </configuration>
I don't think the File identifier auto generated from DropBox would work under SharePoint Update item part.
I tried that firstly, and the URL generated by the Microsoft Flow, won't work for the service to locate the files under SharePoint, that is why I suggest to navigate to the single file.
For amount of files, currently I don't think this is available.
We may submit an idea on this topic, either create a new action regarding SharePoint update, or add the advanced options when we configure the file identifier.
The error message you posted should be related with the Microsoft Flow server, as I suspect that it can't handle the error message output currently, which should indicate that it should being updated.
Not that I am aware of, but honestly, they made it possible to map SharePoint to my Mac so I haven't needed it. The original scenario was a potential work around until the mapping issue got fixed, as I am the only one in our org with a Mac. Sorry I can't be of more help!
Check out the News & Announcements to learn more.
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Check out our new Discover Your Career Path blog post series and get all the details.