cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Hockeyman9474
Level: Powered On

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

Community Support Team
Community Support Team

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
yegdeveloper
Level: Powered On

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. 

 

 

 

MXJ
Level: Power Up

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
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,551)