Skip to main content

Notifications

Power Apps - Building Power Apps
Suggested answer

Excel Online for Business

(1) ShareShare
ReportReport
Posted on by 31
Hi Experts, I need your help.
 
My data source is an excel spreadsheet saved on a Sharepoint site. The data has been formatted as a table with headers.
 
However,  when I connect and load the data  to the gallery I see the input values in the rows but not the column headers.
 
Can anyone assist please so I can see column headers in the gallery?
 
Thank you
Mx
Categories:
  • Suggested answer
    Ravindra Jadhav Profile Picture
    Ravindra Jadhav 240 on at
    Excel Online for Business
    To View Headers or column Names you can use below formula 
     
     Set(
         myJSON,
         Distinct(
             Ungroup(
                 MatchAll(
                     JSON(
                         DatascoureName,
                         JSONFormat.IgnoreBinaryData
                     ),
                     "([^""]+?)""\s*:"
                 ).SubMatches,
                 "SubMatches"
             ),
             Value
         )
     )
     
    Please Closed the Question, Mark it Solved 
     
    If my answer helped resolve your issue, please consider marking it as solved to assist others facing the same problem. Additionally, giving it a like would be greatly appreciated and motivates us to keep helping
     
    Thank You
    Ravindra Jadhav
  • WarrenBelz Profile Picture
    WarrenBelz 145,445 on at
    Excel Online for Business
    Hi MajidX
    The column headers are the field names that you are actually displaying - they do not form a record in the data, rather they actually identify in what fields the data belongs (so they are not part of the Gallery Items). I suggest you put a Label on top of the Gallery and type in the relevant field names, aligning them with where you have the fields displayed.
     
    Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
    MVP (Business Applications)     Visit my blog Practical Power Apps    Buy me a coffee

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard