SPO List columns are not being recognized by Power Apps (also not internal names)

(1) Share

Report

Posted on by Nuriel

177

Dear all,

I am currently having an issue, that my canvas app does not recognize some few columns of a connected SPO list. I tried using internal names which has worked for me in the past in similar cases, but in case of 1 or 2 columns it says that the column does not exist, both with the visible and the internal name.

I tried refreshing the connected list, removing it from the app and adding it back again - doesn't help.

Any idea what other reason might be behind this and how to fix it?

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (14)

Answers (0)

Pstork1 68,707 Most Valuable Professional on at

Like (1)

Report

Check to see if the Column names have any spaces or other special characters. If they do then the names will be something that includes something like _x0020_ in place of the space or something else for different special characters.

Was this reply helpful? Yes No
Nuriel 177 on at

Like (1)

Report

That is what I meant by the internal name. I already checked that and it doesn't work either for some of these specific columns.

I even created now a new canvas apps from scratch with an edit form and just checked the columns one by one and they do not appear in the selection of the column datacard which I can add. For some reason power apps does not see them as available in the list.

Was this reply helpful? Yes No
mstavra 247 on at

Like (1)

Report

Create a new SharePoint list based on the existing list where you are experiencing the issue. Since this new list will be blank, add it to the app and check if those columns appear.

If the columns still do not appear in the new list, check if your column names conflict with PowerApps/SharePoint reserved words.

Was this reply helpful? Yes No
Suggested answer

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (1)

Report

hey,

did you rename the columns after the list has been connected to the app? If so, powerapps only recognizes the original names and not the renamed ones.

If the Post help you solve your issue, please mark it as verified answer and give it a like so we can help other in the community with similar issues

Greetings

Was this reply helpful? Yes No
Nuriel 177 on at

Like (1)

Report

Hi,

@mmbr1606: no, in the list in question I did not rename any columns after connecting to power apps for the first time. But even when I renamed columns in the past, it was not a problem, a simple refresh of the connector or using the internal name alwayls helped.

And the columns were not recognized, as mentioned, when I even created a new app with this list from scratch.

@mstavra: I tried your suggestion and in fact of 7 currently missing columns 1 did appear now in the app based on the list copy.

But, weirdly enough not the remaining 6. I also checked names for conflicts, but there should be none. I also don't know what would be different with that one column which appeared as opposed to the other ones.

All 7 are by the way lookup columns and no my list is not over the limit of 12 lookup columns (incl. created by etc..)

I also renamed one of those missing columns in the list copy to some random name which definitely can't conflict and created yet another app from scratch: this column still was not recognized

Was this reply helpful? Yes No
mstavra 247 on at

Like (1)

Report

Let's see if this is a general issue or a form only issue.

Create a gallery and try to connect the missing columns. Create a text input and try to set the value to your missing columns.

Was this reply helpful? Yes No
mstavra 247 on at

Like (1)

Report

Are you using the new form (preview) layout or the classic forms in power app? If your are using the new, check the old ones please.

Was this reply helpful? Yes No
Nuriel 177 on at

Like (1)

Report

I am not exactly sure what you mean with new (preview) vs. classic. Is it this first greyed-out option when creating an app in power apps? If yes, it's not available to me.

I have been using the "Select external data" option, selecting the Sharepoint site, then the list and then creating a blank 3-screen app.

Was this reply helpful? Yes No
Nuriel 177 on at

Like (1)

Report

This error I get, whenever I try to connect these missing columns to any kind of object (text, combobox, gallery - doesn't matter) in power apps.

With other columns (incl. other lookup columns) which are recognized, I have no issues

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (1)

Report

Check to verify the actual internal column name by looking at the end of the URL when accessing the settings for that column. The end or the url should have a paramter of field=. Whatever folows the = is the actual internal name of the column in SharePoint, As long as the column isn't a null value that should work in Power Apps.

I think mstavra's comment about preview or classic is referring to the designer in Power Automate.

1 people found this reply helpful.

Was this reply helpful? Yes No