web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Excel Online for Busin...

Power Apps

Suggested Answer

Excel Online for Business

(1) Share

Report

Report

Posted on by MajidX

54

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:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

WarrenBelz 153,781 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Ravindra Jadhav 342 Moderator on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No

Join the conversation