Plaza 365
Plaza 365

No results found for your search

RegisterLog in

2

Power Automate – Save a File to OneLake Lakehouse

Visit article

#automate

Power Platform - General

Category

Oct 5, 2024

Published date

Text

Article Type

AI Summary

  • The article discusses the absence of a Microsoft Fabric connector in Power Automate for saving files to OneLake Lakehouse, requiring a workaround.
  • The process involves getting file content from a SharePoint library by triggering the flow from a new file and using the Get file content action.
  • The URL of the Lakehouse folder where the file will be saved can be obtained by clicking on the properties of the folder in the Lakehouse.
  • To create the file in the LakeHouse, the HTTP with Microsoft Entra ID action is used to interact with the Lakehouse and set up the connection.
  • The first step is to save an empty file to OneLake Lakehouse with a PUT action and a parameter of ?resource=file after the path created in the compose.
  • The final action is to append the file content from SharePoint onto the file using a PATCH method and selecting File Content from the dynamic content.
  • Testing the flow involves adding a file to the SharePoint library and waiting for the flow to trigger, resulting in the file appearing in the Lake House.
  • The article concludes by mentioning various business cases for storing files in OneLake and expressing anticipation for a Fabric connector in the future.

Registered users can view the full text for FREE!

Sign In Now!