PowerApps + Delta Lake

PiotrU
Contributor II

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 ?

PiotrU
Contributor II

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

jacovangelder
Databricks MVP

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. 

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

jacovangelder
Databricks MVP

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. 

PiotrU
Contributor II

PiotrU
Contributor II

I have started creating solution for that: 

Here is initial version with PAT 

https://github.com/lakime/powerappstodelta