topic Re: PowerApps + Delta Lake in Get Started Discussions

PowerApps + Delta Lake

PiotrU — Thu, 27 Jun 2024 12:50:36 GMT

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 ?

Re: PowerApps + Delta Lake

PiotrU — Mon, 01 Jul 2024 10:19:03 GMT

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

Re: PowerApps + Delta Lake

jacovangelder — Mon, 01 Jul 2024 10:39:12 GMT

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.

Re: PowerApps + Delta Lake

PiotrU — Mon, 01 Jul 2024 11:12:40 GMT

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

Re: PowerApps + Delta Lake

jacovangelder — Mon, 01 Jul 2024 12:30:05 GMT

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.

Re: PowerApps + Delta Lake

PiotrU — Fri, 20 Sep 2024 09:06:46 GMT

Quite interesting approach

Connect Power App to Delta table from ADLS Gen 2 | by HK Power Platform Admin | Medium

Re: PowerApps + Delta Lake

PiotrU — Fri, 04 Oct 2024 13:34:40 GMT

I have started creating solution for that:

Here is initial version with PAT

https://github.com/lakime/powerappstodelta