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
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
However trying to use "Autor" as column in a "Search", e.g., to seed the displayed items does not seem to work
Trying to use autocomplete to get all available columns yields
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:
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:
Then look at your title bar:
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
@iAm_ManCat |
Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you! |
Thanks! |
Thanks @iAm_ManCat
The first suggestion gives me what I need, albeit in a very tedious way.
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
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.
Or maybe Search just doesn't work with Sharepoint Column/Display names?
Well, it looks like it's really a problem with Search
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
200 | |
170 | |
62 | |
32 | |
31 |
User | Count |
---|---|
339 | |
269 | |
105 | |
71 | |
56 |