Answered

A question about excel data connect

(0) Share

Report

Posted on by GaryWu

Hi, guys! I changed the name of excel sheet from "sheet1" to "HomePage" and uploaded it on the OneDrive Business. Well. When I try to connect the data from excel, the sheet name is "Table1" not "HomePage". Is there anything I need to change in the powerapps or Excel?

Categories:

Building Power Apps

All responses (6)

Answers (2)

Sort by

ianrimmer67 66 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Gary

'Table1' is actually the name of the table you are trying to connect to and not the sheet name.
GaryWu 26 on at

Like
a
(0)

Report
Copy link

Link copied!

Is there anyway to change the name of Table Name? And in the template, I saw their table name is as same as the sheet name.
Verified answer

ianrimmer67 66 on at

Like
a
(2)

Report
Copy link

Link copied!

If you click anywhere on the table in Excel and click on the 'Design' tab, there you can change the Table Name:
GaryWu 26 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks! I found it.
Verified answer

v-micsh-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @GaryWu,

You could find the documentation below:

Rename an Excel Table

Do take a note for the Important notes for names part listed in the article above.

Regards,

Michael
chalast 11 on at

Like
a
(0)

Report
Copy link

Link copied!

This is indeed the solution of the issue raised