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

Missing Columns

I am creating a PowerApp from a custom list that has 22 columns, but when I am working within the PowerApp web version I am going getting about 5 of the 22 columns to work with. Is there a setting that limits what is returned from a SharePoint list?

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
msmith
Level 8

Re: Missing Columns

Just figured it out. I had to select all the current data fields within the view and select properties. Then click on data and select all the missing fields.

 

 

View solution in original post

8 REPLIES 8
msmith
Level 8

Re: Missing Columns

Just figured it out. I had to select all the current data fields within the view and select properties. Then click on data and select all the missing fields.

 

 

View solution in original post

lmurray
Level: Powered On

Re: Missing Columns

Hi msmith,

 

Could you provide some details for your solution, like screenshots? I'm trying this solution but cannot clearly understand what you did.

 

Thank you!

msmith
Level 8

Re: Missing Columns

Hope this helps

Fields-Within-PowerApps.jpg

 

 

 

oscars
Level: Powered On

Re: Missing Columns

If you want to get the data in a label, you have to use:

 

Author.DisplayName

Editor.DisplayName

HelloWorld1
Level: Powered On

Re: Missing Columns

Hi MsSmith,

 

Thank you for the screen shot but I must be using a different version of Powerapps? I don't have the same looking screen you do when trying to follow the steps but I am having the same issue. I have a list with about 20+ columns but only about 6 are showing up from the data source.

HelloWorld1
Level: Powered On

Re: Missing Columns

Wow so odd moment....it is a different version but in case people are having same problem the functionality is the same as explained by mssmith except in a newer version of powerapps you have to click where it says "Fields" and then a discoverable list appears where you can add the additional columns.

Microsoft Ram3
Microsoft

Re: Missing Columns

Were you able to figure this out?

I was trying the same but cannot find the options as described in the previous solution.

I've attached a screenshot for reference. I've about 8 more fields which don't appear anywhere and I don't see a way to retreive them.
Annotation 2019-09-26 133253.jpg

Highlighted
R3dKap
Level 10

Re: Missing Columns

Hi @Ram3,

The interface for managing the fields that are visible in a Form control has changed not so long ago. Now, when you click on the Edit fields link of your form's property panel it shows the the panel that's shown in your screen capture. That panel lists only the fields that are available in the form.

If you want to add more fields from your datasource, you have to click on the Add field link:

 

Image 2.png

Hope this helps,

Emmanuel

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

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

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (10,141)