cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
zuurg
Resolver I
Resolver I

Sharepoint List Column Names are different in PowerApps Lookup than what they actually are

I have a Sharepoint List that I'm using in my Power Apps application that has the following structure:

Control Structure.PNG

For some reason, when I'm trying to do a Lookup in the table using the following code:

 

LookUp('AES Hot Add Controls',Role="Teams Notification" && Team="DMR",Team)

 

It doesn't return the correct value.  When I look at the dropdown to see what the table data looks like, here's what I see:

Table Data.PNG

 

So the "Role" column is being referred to as "Title" (far right), the "Team" column is being called "Details", the "Resource" column is showing correctly, and the "Details" column is being called "Details0"

 

Can anyone explain why the column names are all jacked up?  I understand the "Role" column part because it was previously called Title when I first created the list, but you'd think that it would now be using the actual column name and not the original one.   The bigger concern is the Details and Details0 nonsense.   I have already tried Refreshing the Data Connection and it does the same thing.

1 ACCEPTED SOLUTION

Accepted Solutions
Drrickryp
Super User
Super User

@zuurg 

Welcome to SharePoint he11.  When you rename columns in SharePoint, it retains the original (internal) name as well as the new Display Name.  That is the reason for the advice to not change the column names once they are created.  Some functions in PowerApps use the internal name and others use the display name.  To find out the internal names for your columns see this reference.  https://www.sharepointdiary.com/2011/06/sharepoint-field-display-name-vs-internal-name.html#:~:text=...  

View solution in original post

3 REPLIES 3
Sunil-Narnaware
Super User
Super User

@zuurg There is an awesome article The Ten Commandments of SharePoint in PowerApps. - Power Platform Community (microsoft.com) by @Drrickryp  May not answer all your queries but at least your title column challenge..

Thanks!  I'm not so concerned about the Title column as I am about the others.    🙂

Drrickryp
Super User
Super User

@zuurg 

Welcome to SharePoint he11.  When you rename columns in SharePoint, it retains the original (internal) name as well as the new Display Name.  That is the reason for the advice to not change the column names once they are created.  Some functions in PowerApps use the internal name and others use the display name.  To find out the internal names for your columns see this reference.  https://www.sharepointdiary.com/2011/06/sharepoint-field-display-name-vs-internal-name.html#:~:text=...  

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (2,437)