PowerApps + Delta Lake

[PiotrU]

Is there any native way to Insert data from PowerApps directly into Delta Lake?

I can of course create a workflow - and push the data via API, but is there any alternative ?

[Kaniz_Fatma]

Hi @PiotrU, There are a couple of ways you can achieve this:

1. Synapse Link for Dataverse:

   • Set up Synapse Link for Dataverse in your Azure environment.
   • Use the Make.powerapps UI to create a near-real-time data replication link from Dataverse to your chosen Delta Lake (which must be in the same region).
   • Once the link is established, you can:
     • Read Data: Access Dataverse data in Fabric directly from Power Apps.
     • Write Data: Use Power Apps to add, edit, and read data from the linked Delta Lake¹.

2. Upsert using MERGE SQL Operation:

   • You can upsert data from a source table, view, or DataFrame into a target Delta table by using the MERGE SQL operation.
   • Delta Lake supports inserts, updates, and deletes in MERGE, and it provides extended syntax beyond t...².

Feel free to explore these options and choose the one that best fits your requirements! 😊

[PiotrU]

This does answer my question, but it's overkill IMO, let me try to do something with delta-io

[jacovangelder]

Had the same task in a previous assignment. There is no other way than starting a job through the API from within PowerApps. For that you need running compute and leverage Serverless most likely. 

[PiotrU]

I would imagine - delta-io on azure function accessing the delta lake based on api trigger / queue etc. 

[jacovangelder]

Haven't thought of that actually, yes that will work! But still you need a seperate azure function for it, which is a bit cumbersome still I would say.