cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

Rename Data Source

DataSource Screenshot.jpg

This is so annoying. Is there anyway to name the datasource other than the default Table1, Table2...ETC. Unless I can, I have to go back through all my code and change it.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Rename Data Source

It should be the same name as you table. Can you change the name of the table on the backend and try to import again?

View solution in original post

4 REPLIES 4
Highlighted
Microsoft
Microsoft

Re: Rename Data Source

It should be the same name as you table. Can you change the name of the table on the backend and try to import again?

View solution in original post

Highlighted
Community Support
Community Support

Re: Rename Data Source

Hi @Hockeyman9474,

 

As shared by @mayuro, the table name is queried from the datasource side.

I suspect the Table1 is from an Excel file stored under OneDrive for Business, please take a look at the following article for table re-naming within Excel:

Rename an Excel table

Other datasource table, such as Common Data Service entity, SQL Server table, PowerApps would load the 'table' Name defined within the corresponding Data source. There is no direct way to change the table name within PowerApps.

Check the article below for more details:

Understand tables and records in PowerApps

Regards,

Michael

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Advocate II
Advocate II

Re: Rename Data Source

If your Datasource is an Excel Spreadsheet, it will automatically generate Datasource names like Table1. 

 

You need to override this in Excel.

 

Excel has two ways of naming ranges of cells: as "ranges" and as "tables". PowerApps uses the latter. 

 

PROCEDURE:

 

1. Go into Excel

2. Select your data

3. Click on Format as Table (or just click on one of the Table Styles under the Tables Ribbon tab)

 

Excel - Format As A Table.png

 

4. On the Tables tab, click on Rename

 

Screen Shot 2017-05-26 at 15.48.33.png

5. Give your table the name you want to see in the PowerApps DataSource (in the example below, I used MyPowerAppsData)

 

Screen Shot 2017-05-26 at 15.49.43.png

 

6. (Optional) Rename the Sheet at the bottom to the same name so it's easier to locate later.

 

Do not use the Excel Ranges naming feature. 

 

 

 

Highlighted
Frequent Visitor

Re: Rename Data Source

 I have named my tables in my workbook, then moved the workbook to my OneDrive, but PowerApps Connections still shows "Table1", "Table2", etc.

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,648)