How to transfer files from onedrive to onelake (lakehouse) with powerautomate?

Hi all,

I need help with this problem I'm having. I want to transfer Excel & Csv files from onedrive to onelake inside my lakehouse within powerautomate however for some reason I can't get this to work.

I know there is no dedicated action inside powerautomate that allows you to do that, so I would have to use a workaround.

I tried to use the 2 step HTTP request method where you first create an empty file then append the file content to the empty file. But that doesn't really work, because when I try to open the file from onelake it says the file is corrupted. When I check the file size in onelake its size is bigger than from the source (onedrive in this case).

So I kind of feel stuck and don't know what to do at this point?

Can someone with experience tell me how I can solve this?