web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / ShowColumns used with ...
Power Apps
Unanswered

ShowColumns used with a sharepoint list only recognizes internal column names

(0) ShareShare
ReportReport
Posted on by

I have found that ShowColumns in PowerApps only recognizes internal column names. I wonder if there is a resolution that doesn't require me to use internal column names. Perhaps an experimental feature I need to turn off?

 

The screenshot below is an example. "CapaNumber" is the display name of the column name, "evmn" is the internal name that I had to find using the instructions in this link (Find the internal name of SharePoint column — HelpDesk for Office 365, MS Teams, and SharePoint 1.x documentation (plumsail.com)). 

 

It seems pretty unsustainable to have to look up the internal name of a SharePoint column every time I want to use this ShowColumns function. Is there a better resolution to this?

 

AndrewM114DD_0-1621004012347.png

Categories:
I have the same question (0)
  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @AndrewM114DD 

    Unfortunately, ShowColumns, SortByColumns and a couple other functions still require the real field name to be used.

    The inclusion of using the defined name over the real name is only within the past 2 years.  Before that you always had to use the real name for everything. 

    There used to be a feature to turn on and off to allow formulas to use defined names, but that feature was eventually just turned on by default and disappeared.  However...that feature still only applied to the functions that supported it (Filter, Distinct, Choices, etc.)  The ones mentioned above did not honor that setting even back then...and they still don't.

     

    I hope this is helpful for you.

  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @AndrewM114DD 

    How did this work out for you? Were you able to utilize the suggestions? If you're still having problems, feel free to post back. If not, then please review the answers to your post and mark one as a solution so that others who might be looking for similar solutions can find them quickly. Thanks!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 542 Most Valuable Professional

#2
Haque Profile Picture

Haque 206

#3
Kalathiya Profile Picture

Kalathiya 201 Super User 2026 Season 1

Last 30 days Overall leaderboard