Power Platform Community Forum Thread Details

Hello Everyone,

I am very new to PowerApps and would like to seek some help with the community

background

I was tasked to build an app in PowerApps that browses data and do updates into a Master Table. This Master Table sits on data bricks.

so, what i have done is to create a delta table in data bricks and mount it to synapse sql external table(db). I then connect my powerapps using sql connector to pull the data... and this is where the problem starts...

while i am able to connect and "browse" the data, I have 3 problem.

1. The master table does not have a primary key

2. PowerApps complains that the data source is read-only (learned today external tables are by default ro)

3. how do I reflect the changes from external table/database (ie. synapse external table, dataverse) back to databricks

now I don't know how to go about this complexity..im trying to read about data verse but i don't know if this will lead to the solution or another potential dead-end

appreciate if anyone can suggest a solution. I couldn't get any reference articles with same problem

thanks a lot

Categories:

Building Power Apps