Saving Files to OneLake from PowerAutomate

[joeparkinson]

Has anyone successfully saved a file into onelake from powerautomate? I'm struggling to understand if its possible

[joeguicearnold]

This seems to be doing what you're asking about.

https://hatfullofdata.blog/power-automate-save-a-file-to-onelake-lakehouse/ 

[frithjof_v]

I created an idea in the Power Automate forum to have a Lakehouse connector, please vote:

https://ideas.powerautomate.com/d365community/idea/8bb4e21b-ba3f-ef11-b4ae-000d3a05ba58

[esun2c]

you just need to create a flow in power automate to push your files to the Azure Data lake and then in Fabric, you need to create a shortcut off of your data lake container.

[joeparkinson]

how would i do the push to the azure data lake? 

[esun2c]

There is a Azure blob storage connector in Power automate. you can push your files automatically to azure Storage Account. Next step is create and schedule a pipeline in fabric or ADF to move your files from Blob Storage account to Data Lake Gen2. 

[joeparkinson]

Ah I see what you mean. I'm looking to move something directly to fabric - I dont want to push it via an intermediary step

[v-cboorla-msft]

Hi @joeparkinson 

Thanks for using Microsoft Fabric Community.

Unfortunately, directly saving files into OneLake uisng Power Automate is not currently possible. OneLake currently doesn't have a dedicated connector within Power Automate, limiting options for direct interactions like file saving.

I hope this information helps. If you have any further questions please do let us know.

Thanks.

[v-cboorla-msft]

Hi @joeparkinson 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.

Thanks.

[v-cboorla-msft]

Hi @joeparkinson 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
If you have any question relating to the current thread, please do let us know and we will try out best to help you.
In case if you have any other question on a different issue, we request you to open a new thread.

Thanks.