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
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
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

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

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,827)