web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Map Sharepoint list co...
Power Apps
Unanswered

Map Sharepoint list columns to gallery items

(0) ShareShare
ReportReport
Posted on by 19

I'm brand new to Power Apps and apologize if this is a really obvious question, but here is my current problem:

I've got a Sharepoint list with a bunch of columns and I want to make a basic app that allows users to scroll vertically through all the column names in a gallery and select checkboxes next to the ones they want.

 

Is there a way to map all the gallery items to reflect the list columns instead of the list items?

Categories:
  • CU18061035-1 Profile Picture
    Microsoft Employee on at

    hey @PowerApps12 

     

    in a gallery you see the list items from your sharepoint list. in that gallery item you can theoretically show the value of all columns.

    when you select the gallery on the left you see layout on the right, there you can choose whatever layout you want.

    when you click the pen icon of the gallery (when it is selected, you can insert as many text labels as you want) This will be inserted to all items in the gallery and not only the first one.

    mmbr1606_1-1710510601950.png

    select the text label you want to insert data to like the screenshot below.

    in the text property of the label you type ThisItem. and intelisense will list you all columns you have on your list.

    if you add new ones while power apps studio is open, please make sure to refresh ot from the data tab on the left side of your studio

    mmbr1606_2-1710510762153.png

    Let me know if my answer helped solving your issue.

    If it did please accept as solution and give it a thumbs up so we can help others in the community.



    Greetings

  • PowerApps12 Profile Picture
    19 on at

    Thanks for the quick reply! Unfortunately, I'm looking for a way to have the gallery show all of the column names/titles (one column title per gallery item). Unless I'm misunderstanding it, your method only allows me to show the value of specific columns (not their title) and they would repeat on each new gallery item.

  • CU18061035-1 Profile Picture
    Microsoft Employee on at

    No it will be not repeated because the gallery will show all items from the list. You could build a excel list lile exp by placing the text labels next to each other and place text labels on the top of the table. I have also done something like this

  • PowerApps12 Profile Picture
    19 on at

    I feel like we may be talking past each other right now. This is what I'm looking for:
    I've got a Sharepoint list that looks something like this:
    Screenshot 2024-03-15 153544.jpg

     

     

     

     

     

     

     

    And I want the column titles to appear as gallery items vertically (like rows) like this:

    Screenshot 2024-03-15 153905.jpg

     

    Maybe I'm misunderstanding, but I don't see how that's possible so far.

  • CU18061035-1 Profile Picture
    Microsoft Employee on at

    Im not ony.computer right now so i can not show what i was trying to explain.

    How many columns will i have in your list?

     

    I will share my screenshot later today if nobody else

  • PowerApps12 Profile Picture
    19 on at

    So far I've got about 30 columns. I'm hoping for a dynamic solution because I don't know if more columns will be added or removed in the future.

  • CU18061035-1 Profile Picture
    Microsoft Employee on at

    i have done somethig like this:

    mmbr1606_0-1710523449976.png

     

    The column above are text labels and the value below it are text labels with values from the columns.

    i dont think that this will work with our setup because showing 30+ columns wont fit on the screen.

     

    and aditionally i dont think that dynamic will work because you need to put the columns on the screen or form manually. At least this is my knowledge, i have never seen a dynamic way to do it.

     

    Let me know if my answer helped solving your issue.

    If it did please accept as solution and give it a thumbs up so we can help others in the community.



    Greetings

  • PowerApps12 Profile Picture
    19 on at

    Thank you, I was afraid this would be the case. That's why I wanted the column names to be vertically oriented like rows - so they could fit on the screen by scrolling up and down.

    I don't actually need the entries of the list to be reflected on my app, just the column names, but I was hoping not to use manually named labels.

    It's too bad this isn't possible. Thank you for all your help though!

  • CU18061035-1 Profile Picture
    Microsoft Employee on at

    in my point of view this is not possible.

    or do you want to make new entries thru the app, without the stored entries to be shown there. And for example just have the data in the sharepoint list? this would be possible if you are using a form for example, or simply put the input controls on your screen and use the patch function on button click.

     

    let me know if this is what you want to achieve.

     

    Let me know if my answer helped solving your issue.

    If it did please accept as solution and give it a thumbs up so we can help others in the community.



    Greetings

  • PowerApps12 Profile Picture
    19 on at

    Thanks, but that's not what I want to achieve. I don't want to add any new columns through the app, but only display existing columns of the list in the app. Column changes would only be made directly on the list and would have to be reflected in the app afterwards.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 243 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 190 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 135

Last 30 days Overall leaderboard