cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

Flow- One drive- Copy vs replace

Hi All

Refer https://docs.microsoft.com/en-us/power-bi/refresh-data

One drive requires UPLOAD and REPLACE to refresh PBi.

Flow apparently COPIES OVER the existing file which according to the referred article looses one drive refresh.

Is it possible to upload and replace files in onedrive for business from power automate.

Stay home, keep your loved ones safe

13 REPLIES 13
Super User II
Super User II

@navaidm  shure you can if you upload by url

yes.PNG



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

@ChristianAbata Tnx for the reply.

Tried but flow fails. File path or folder not found.

First I check email and save attachments to "transfer" folder in onedrive using "create" file action.

Flow works fine upto this point.

Then I try to upload to final folder in onedrive using your suggestion as follows.

 

I copied the path using  excel / info/copy path (works well with power queries and Bi)

Source file in "upload to URL"

https://xxxxx-my.sharepoint.com/personal/yyyyyyy/Documents/Transfer/EYEng%20TR%20Detail.csv

Destination file 

https://xxxxx-my.sharepoint.com/personal/yyyyyyy/Documents/Reports/EYEng%20TR%20Detail.csv

 

 

flow1.PNGflow2.PNG

 

ok @navaidm  please could you show me what do you have inside UploadTr



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

flow3.PNG

@navaidm  see this example, What you need to add into destination file path the name of an existing folder and then at the end the filename with extention.

upload.PNG

 

 



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

@ChristianAbata Tnx. (Couldn't find any help or article on google with upload to url)

I changed flow as you recommended 

 

flow6.PNG

 

Error changed. Now it says forbidden

It is my account.

 

 

flow4.PNGflow5.PNG

hi @navaidm  the folder report exist?



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

 

 

@ChristianAbata 

Yes, Please Refer screen shot

 

flow7.PNG

 

flow8.PNG

@navaidm please could you copy and paste your url file in a new tap to see if you are redirected to your file or not. Just to know if you can access to the file.

 



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

Copied from flow and pasted in new TAb. File downloaded

@navaidm the url file is from the file previusly created right? so please try to use the file identifier of the previous creation file to add it into your source url. 



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

@ChristianAbata  I am not sure I understand.

How do I get the previous file? 
File is replaced each time the flow runs. The Source URL remains the same. The destination file remains the same.

The previous file has been overwritten.

 

@ChristianAbata I saved the file in share point Document folder. Then tried uploading to Onedrive. Still forbidden.

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (22,776)