Unanswered

Getting data from SQL Server table with composite key

(0) Share

Report

Posted on by gax700

Hello everyone,

I'm trying to get data from a SQL Server table that has a primary composed key (3 columns). The new app procedure builds the interface correctly but doesn't fetch any data.

I've tried to change the primary key to a single autoincrement ID column and everything works like a charm.

Is this behaviour by design? Anyone else experieced this?

Thanks,

Cris

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

v-yamao-msft on at

Like (0)

Report

Hi gax700,

What are the column types of the three columns? Do you have entered data for each column?

I am using SQL Server On-Premise, to test this issue, i set a column(column type int) as primary key, then when i create an app based the table, I found that all the data in the table are shown on the app. I can also write back to the table from the app.

Before you change the primary key to a single autoincrement ID column, which column were you using as the primary key?

Best regards,

Mabel Mao

Was this reply helpful? Yes No
gax700 24 on at

Like (0)

Report

Hi Mabel,
this is the table definition. No way to show data into the app.

Thanks,
Cris

Was this reply helpful? Yes No