cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dimitri-VDL
Advocate IV
Advocate IV

Sharepoint list missing columns in Gallery

I have a Sharepoint list with lets say 20 columns.

When connecting this list in my PowerApp, I add this source to the Gallery control (Items) but I can't seem to have access to all columns to set their value into a label for example.

 

I have only 10 columns available ... None of the NOT available columns are lookups or anything "stranger" than normal, they are just  "single line text" columns ...

 

I looked into this: https://powerusers.microsoft.com/t5/General-Discussion/Missing-Columns/m-p/60802#M25121

But I don't us Forms so this does not apply.

 

Anyone has any idea?

Kind regards.

 

15 REPLIES 15
v-monli-msft
Community Support
Community Support

Hi @Dimitri-VDL ,

 

Did you mean that some text columns does not show in the dropdown list here after you select Edit fields?

Capture.JPG

3.JPG

 

If so, please try to set the Text property of the Label control in the first part of the gallery to:

ThisItem.ColumnName

And see if the column could show correctly.

 

Regards,

Mona

 

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-monli-msft 

 

That is correct, only some of the columns from SharePoint are showing in the dropdown AND in the formula bar ThisItem.PropertyName. The missing items are simple text fields.

 

Any update on this?

@v-monli-msft Can someone from MS suggest me anything please?

Anonymous
Not applicable

Hi @Dimitri-VDL while reviewing similar posts from the community I found the following suggestion:

 

To verify the columns available and their names you can run a simple test.

Create a button and in the OnSelect put ClearCollect(colTest, Fournisseurs)

Then in the menu bar go View > Collections

 

You should be able to see what columns are available and their names. In the past I have had issue where the column had an internal name and I was looking for the external name which was differnt.

 

Here is the link to the thread - https://powerusers.microsoft.com/t5/Expressions-and-Formulas/Missing-columns-in-search-formula-but-n...

 

If this does not solve your problem please let me know so I can research further. 

 

@Anonymous 

@Anonymous 

Wow great suggestion, will use this more often, but unfortunately I still have the same amount of columns available Smiley Sad

 

Thank you for the suggestion, if you have any question let me know!

Hi @Dimitri-VDL ,

 

Sorry for the late response. Do you still have this issue? What are the column types that are missing from PowerApps? Could you please try to add a new column and test? How many columns do you have exactly totally?

 

Regards,

Mona

 

 

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-monli-msft 

Yes still having this, they are ALL either single or multiple line text. No complex things here, strange, I never had this before ...

 

I tried adding a new one but same thing, doesn't show up ...

I have this much that are "visible":

sp.png

I am having the same issue. I can't find a lot of columns in the value section of the drop down.

 

I have been trying to add a drop down with a column from a SharePoint list. I can see the datasource and a lot of columns although there are spaces in the column names. Looks like PowerApps is having issues getting the columns which are actually drop downs in the SharePoint List. If this is not resolved, I guess we need to add a new list or a data source with just these values which are already drop downs in SharePoint.

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (7,239)