cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Microsoft
Microsoft

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
Microsoft
Microsoft

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

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

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

 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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (11,479)