Unanswered

Azure SQL server - Add/delete/Edit row options not showing up

(0) Share

Report

Posted on by CBKM

I'm new to power apps and starting building my first app. I'm using Azure SQL server table(SQL Authentication credentials with write back privilge) as my datasource for my app. I see the rows from the sql table show up in the app, however I'm not seeing the options to "Add", "Edit" and "Delete" rows.

How to make those options available. Also in the tree view bar on the left screen, I do not see "Edit Screen1" show-up.

Any clue what I'm missing here.

Thanks in advance.

-KM

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report

Hi @CBKM

The most likely cause of this is that the table that you're using doesn't have a primary key column. Can you confirm that you've defined a primary key on your table?

Was this reply helpful? Yes No
CBKM 18 on at

Like (0)

Report

Hi - Correct, That was the issue. I defined PK column on the table and Edit/Delete/Insert options show-up now.
However when I try to insert/edit a table row, i m getting following error. See attached.
I'm connecting to Azure SQL server and that server allows connection from any azure services(like PowerBI etc.)

PowerApps error.PNG

Was this reply helpful? Yes No