You’re offline. This is a read only version of the page.
2
I'm using Power Automate with a custom HTTP pre-authorized connector to copy files from SharePoint to my Microsoft Fabric Lakehouse's "Files" section (ADLS Gen2).
My flow: SharePoint "Get file content" (base64) -> base64ToBinary() -> HTTP PUT/PATCH to ADLS Gen2 REST API. Images (JPG, PNG) are transferred, but they end up corrupted in the Lakehouse.
I can successfully copy the image from Lakehouse to SharePoint when i upload it manually. I'm not sure what i'm doing wrong. Any help is appreciated!
@Michael E. Gernaey, thank you for responding! I tried using the "content" directly and also tried base64, but neither resolved the issue.
My files are around 4 MB, and I even tested with a smaller file, but it still didn't work.
I followed the approach mentioned here: https://hatfullofdata.blog/power-automate-save-a-file-to-onelake-lakehouse/
https://hatfullofdata.blog/power-automate-save-a-file-to-onelake-lakehouse/. First, create the file and then append. The reason I had to do that was when I used the URI: https://onelake.dfs.fabric.microsoft.com/workspace/lakehouse/Files/test.jpg, it said I was missing a required header (An HTTP header that's mandatory for this request is not specified.). Then I tried the article about first creating the file and then appending and flushing it.
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
Share
Report
All responses (
Answers (
