cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SaWu
Level 8

Oddities with Sharepoint Column Names

Please be so kind as to read my full post before responding.
Thank you for your consideration.

In one App my boss built for his own PowerApps training, and for which he asked me for help with his SearchBox, I came across the following oddity.
He built his App basically with Standard prefabricated Sharepoint -> GalleryScreen/DetailScreen/EditScreen template.

His Sharepoint list looks like this
image.pngimage.png
So, as far as I can see, there should be an "Autor" column/field for this table.

This seems to work for setting the Text property of a label inside a Gallery for that Sharepoint List
image.png

However trying to use "Autor" as column in a "Search", e.g., to seed the displayed items does not seem to work

image.png

Trying to use autocomplete to get all available columns yields
image.pngimage.pngimage.pngimage.pngimage.pngimage.pngimage.pngimage.png

There, I don't see the "Autor", "Autor Epoche", "Inhalt 1", "Inhalt 2", "Stichworte" columns at all, but some weird 4-character columns.
I am guessing those are the logical names of those columns.
My guess is that I only see the Display/Column Names of the columns but not the logical names and that for some reason I can use the Display Names for setting Label.Text, but not inside Search/Filter etc which seem to require logical names.

Session ID: 6c9c0138-3a73-4da4-ba08-4b6133eb4399
PowerApps 3.19051.14
This version is recent enough that the "Use Column Names" features is turned on.
The toggle in the Advanced settings for that isn't there in any case.

My questions:

  1. Is my understanding of those 4-character columns correct?
  2. How do I know which of those 4-character columns belongs to which of the columns which I can't find?
3 REPLIES 3
Highlighted
Super User
Super User

Re: Oddities with Sharepoint Column Names

Yes, those column names are the SharePoint internal names that were originally used and then were renamed with proper display names afterwards

.

To view the column name, go to list settings:

Click on the Column name:

 

image.png

 

Then look at your title bar:

 

image.png

 

You'll see there it has &Field= and after that is the original name of the column.

 

Also, for display names of columns you should use single quotes 'Autor' rather than double-quotes "Autor" which is explicit column name

 

Hope this helps!

 

Cheers,

ManCat




Don't forget to 'Mark as Solution' and 'Thumbs Up' those who deserve it!
SaWu
Level 8

Re: Oddities with Sharepoint Column Names

Thanks @iAm_ManCat 

The first suggestion gives me what I need, albeit in a very tedious way.
image.png
Is there no easier view to get Sharepoint proper column names?
I was thinking of something like for CDS/Dynamics fields which I am more familiar with
image.pngimage.png

 

I think I am not reading your comment on quotes right.
I tried replacing those double quotes in my Search with single quotes but it doesn't work.
Here are some screenshots of some of the syntax variations I've tried.
image.pngimage.pngimage.pngimage.pngimage.pngimage.png

Or maybe Search just doesn't work with Sharepoint Column/Display names?

SaWu
Level 8

Re: Oddities with Sharepoint Column Names

Well, it looks like it's really a problem with Search

image.png

Helpful resources

Announcements
firstImage

PowerApps Monthly Community Call!

Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.

Top Community Contributors for September  2019

Top Community Contributors for September 2019 🎉🎉

Let's thank our top community contributors

firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 271 members 4,343 guests
Please welcome our newest community members: