Answered

Multiple columns (headers in table) not available as fields in vertical gallery

(0) Share

Report

Posted on by AmitKrause

Hi,

I'm trying to import an excel file and make the vertical gallery show 2 headers of the table (title and subtitle). And of course, there's a problem (: Multiple headers are not available as fields. Funny, cause I only want two fields and one of them isn't showing. Such is life.

I'm only using one source file (excel). And the data in the file is marked as a table.

So there are different ways to connect an excel file and unfortunately they give different results:

When I use the connector 'import from Excel', I see only 9/16 columns selectable as fields
When I use the connector 'Excel Online (Business)', I see the same columns plus a few more but still not all.
When I use the connector 'OneDrive for Business', it gets weird but somehow it's the best option: The names of the headers get messed up (every space in the name of the header gets replaced with _x0020_) but I see almost all columns. Unfortonately not all and precisely not the ones I want.

Can you help shed a light on this problem? Much appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

BrianS 2,407 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

The _x0020_ issue happens in many places in PowerApps and is the reason most Makers do not use spaces in field names even in SP. What type of data is in the columns that are not showing up? They are definitely in the table? Any chance you can migrate t0he data to a Sharepoint list to create the app? Excel can be used but it creates headaches

Was this reply helpful? Yes No
Verified answer

AmitKrause 95 on at

Like
a
(0)

Report
Copy link

Link copied!

I'm working with Forms to Excel tot populate the excel table. It works quite nicely as it's "real time" meaning that when someone fills out a survey, the excel table/file updates immediately and a new record is visible.

I don't know what happened exactly but when I'd made a new Forms to Excel and connected the output file of that through Excel Online for Business, all the columns (headers) showed up without weird characters.
Maybe I'd messed around too much in the header section of the original file ¯\_(ツ)_/¯.

I don't know if Power Apps is able to change with the excel file automatically but at a first glance I think it can't. It does when I renew/update the source file in Power Apps. Maybe I can arrange something with Power Automate to automatically update in the app.

I guess it's solved now. Thanks for looking into it.

There's a problem with the search function syntax. Don't seem to be able to get it right. I might open a new topic for that.

Was this reply helpful? Yes No