Unanswered

Power Apps as an OLTP front end?

(0) Share

Report

Posted on by Community Power Pla...

I'm currently testing power apps for my organization as a potential UI point for users. Since we have a lot of departments that interface, and a large on premise footprint, I need to get data into PowerApps and out of PowerApps in an OLTP fashion.

In case you don't know how OLTP works essentially we can't use UPDATE or DELETE statements. Any UPDATE or DELETE statements sent back to the OLTP server need to be in the form of INSERT statements that contain the entire row of data to be updated or deleted. These INSERTED rows are then timestamped by the SQL Server on premise. Furthermore to select data from OLTP tables, Power Apps needs to filter the data by timestamp.

My OLTP Database is an on premise SQL server that I have set up with the Azure On-Premise Gateway.

Has anyone built anything like this before?

It seems difficult to get data out of PowerApps into On-Premise SQL Server, does anyone have experience with that?

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

v-yutliu-msft on at

Like (0)

Report

Hi @Anonymous ,

Do you want to import data from SQL to PowerApps?

Firstly, powerapps could not save data.

I assume that you want to import data into CDS, one serivice of PowerApps.

If so, I suggest you kown more about data intergration, a good way to make this.

Here's a doc about it in details for your reference:

https://docs.microsoft.com/en-us/power-platform/admin/data-integrator

Best regards,

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks for the reply.

Could you elaborate on "could not save data"? I seem to be able to get data into Power Apps easily. It's getting it out that seems tricky...

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Have you tried constructing the relevant statement with the Patch formula to update back to the sql table?
There is a myriad of threads on this topice here.

Was this reply helpful? Yes No