Skip to main content

Notifications

Community site session details

Community site session details

Session Id : gErPIE+MPvuzWBOU0h/FaU
Power Apps - Building Power Apps
Unanswered

Getting data from SQL Server table with composite key

Like (0) ShareShare
ReportReport
Posted on 30 May 2017 09:36:55 by 24

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:
  • gax700 Profile Picture
    24 on 31 May 2017 at 06:21:37
    Re: Getting data from SQL Server table with composite key

    Hi Mabel,

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

     

     Capture.PNG

     

    Thanks,

    Cris

  • v-yamao-msft Profile Picture
    on 31 May 2017 at 04:12:02
    Re: Getting data from SQL Server table with composite key

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 78 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 42

#3
mmbr1606 Profile Picture

mmbr1606 41 Super User 2025 Season 1

Overall leaderboard