Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Unable to find Sharepoint columns in Lookup



I have been looking for hours already, and found a lot of similar but not the same issue. I am working with multiple Sharepoint Lists with simular data and a variable to select the source for multiple LookUp-formulas. However, PowerApps seems to miss a couple of columns. Does anyone know why? I appreciate the help.


I created a form which asks the user to pick one of the 8 Sharepoint Lists and give a Key to search within on of these 8 Lists. On the same form there are multiple fields who do a LookUp on the two variables. Everything works fine, except that PowerApps is unable to find all the columns. I am not working with formulas on SharePoint (e.g. LookUp columns)


Background info:

In order to create the Sharepoint Lists I have uploaded 38 columns from Excel. 12 of which are date, 9 boolean, 15 string and 2 are numerical. I know Sharepoint has limits on the amount of datatype columns, but I should be below treshold. I have created 8 Sharepoint Lists with the data. Each List contains different records, but the columns are the same.

Level: Powered On

Re: Unable to find Sharepoint columns in Lookup

To add:


I have looked at the internal names in the SharePoint list. I have not changed column names in Sharepoint and made sure that I used the internal names.

Helpful resources


Power Apps Community User Group Member Badge

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


Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Kudoed Authors (Last 30 Days)
Users online (3,871)