Sharepoint - Import From Excel Field names in PowerApps

(0) Share

Report

Posted on by zmansuri

6,048 Super User 2024 Season 1

Hello,

I have an excel table with 200 columns. I am importing that list in Sharepoint to create new list. But in the PowerApps column names are like this "field1", "field2" instead of the actual names. I checked in SharePoint and although displaynames were correct the internal column names were "field1", "field2" etc.

Any solution? Data is not important but i don't want to manually create 200 columns in sharepoint.

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,714 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @zmansuri ,

Welcome to the Excel Import wizard . . . yes - that is exactly what it does with the "underlying" file name. The only way to avoid this that I know of is to create the list with the names you need and then (for a small list) paste the data in with Edit in Grid view or put the file in OneDrive and format the data in a Table and do this. I brought in 75,000 records in batches of 10,000. Ensure you increase the pagination in the setting of "List rows . . ."

Please click Accept as solution 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 Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @WarrenBelz
zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

Also i was deep diving this issue from yesterday and i found a working solution just in case you need it in future. Instead of creating it from SharePoint. Use Export function in excel. And that will keep the header name same as internal names with data. Attaching image for reference.