Unanswered

Why is my Canvas app displaying the wrong unique ID for the record being displayed?

(0) Share

Report

Posted on by Community Power Pla...

Hello,

I have a simple Canvas app that includes a gallery that lists data from an Excel spreadsheet. The Edit form correctly displays the corresponding detailed data. Unfortunately, the gallery is displaying incorrect unique IDs for the items and I can't figure out why. Since the unique ID is incorrect, the resulting updates via the Edit form are updating the wrong row.

Gallery > Text = ThisItem.ID (same for other fields in gallery: ThisItem.ContactName, ThisItem.Title, etc.)
Gallery > OnSelect = ThisItem.ID Select(Parent) (same for other fields in gallery: ThisItem.ContactName, ThisItem.Title, etc.).

Data updated correctly before I configured the gallery > Items > SortByColumns(Filter(Contacts,StartsWith(ContactName,txtSearchBox.Text)),"ContactName",SortOrder.Ascending)

It's odd that all of the fields are configured similarly, however, the ID field pulls "1" for the first row in the spreadsheet, instead of "256" which is what it should be.

Help!

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous

How are you assigning ID in your Excel table?

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

Like (0)

Report

So I would have a unique ID to identify each row of data.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous

Yes. I understand why. How are you doing that? Excel tables don't have an index by default.

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

Like (0)

Report

Defined a table and filled the ID column with:

=ROW()-ROW(Contacts[#Headers])

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous

PowerApps will not import calculated columns from Excel. I suggest that you move your data to SharePoint.

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

Like (0)

Report

Weird because it appears to be pulling in the ID numbers but in numerical order of the SharePoint list not the alphabetical order of the Power BI list.

I just tried with a column filled with Series>Linear>Step Value = 1 so it's no longer a calculated volume but it displays the same value for some rows and nowhere near the correct ID number.

So, it that's the case, how do I define a unique ID or have the app update the correct row of data in the spreadsheet?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous

Set First(Sort(yourtable, ID, Descending)).ID+1 as the default formula for the ID field. This will work even if you exceed the data row limit. If you are using a form, put that in the Update property of the ID card and hide the card.

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

Like (0)

Report

I configured the Text fx for the ID field to: First(Sort(Contacts.ID,SortOrder.Descending)).ID+1

but it displays "2" for all the entries (below if from Edit form).

I can't find the "Update" property for the ID field in either the gallery or the Edit forms.

I really appreciate your help on this problem.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous

There is a typo in your formula

It should be

First(Sort(Contacts, ID, SortOrder.Descending)).ID+1

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

Like (0)

Report

I copied and pasted your formula and this is the result (the "SortOrder." section is removed when I leave the field and reselect it).

Was this reply helpful? Yes No