Flow- One drive- Copy vs replace

[navaidm]

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

[ChristianAbata]

@navaidm  shure you can if you upload by url

[navaidm]

@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

[ChristianAbata]

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

[navaidm]

[ChristianAbata]

@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.

[navaidm]

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

I changed flow as you recommended 

Error changed. Now it says forbidden

It is my account.

[ChristianAbata]

hi @navaidm  the folder report exist?

[navaidm]

@ChristianAbata 

Yes, Please Refer screen shot

[ChristianAbata]

@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.

[navaidm]

Copied from flow and pasted in new TAb. File downloaded

[ChristianAbata]

@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. 

[navaidm]

@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.

[navaidm]

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