Answered

_x0020_

Like (1) Share

Report

Posted on 7 Aug 2017 15:31:25 by Community Power Pla...

Hi all, is there a quick fix for the issue of spaces in Excel files being replaced by _x0020_ in PowerApps? I've got a large Excel file with a lot of info (and therefore a lot of spaces). Thanks

Categories:

Connecting to Data

All responses (7)

Answers (2)

Verified answer

AndyPennell on 01 Sep 2017 at 23:27:09

Like (2)

Report

Re: _x0020_

Its not a bug. As you point out, spaces are important in the PA language. For this reason if a column name (from Excel or any other data source) contains a space (or other "weird" character) it is replaced with an escaped version (0x20 in the case of spaces).

Some data sources offer both an internal name (which is used in the PA language) and a display name (which is shown in the UI eg as a column header in a data table). Excel does not do this.
Verified answer

nickduxfield 497 on 03 Sep 2017 at 08:18:49

Like (1)

Report

Re: _x0020_

As others have mentioned, its not a bug.
First rule of thumb in Ms Access, SharePoint Lists, and any table, Dont crete columns with spaces. Even in website's addressbars you will see %20 to represent spaces, its the same thiing.

In SharePoint you first create a column with No spaces and that creates a clean clear readable Internal Column Name.
Then you can change the display name.
It helps a lot when someone else comes on the job and works on your project, they can easily read whata going on and it wont throw any weird un-troubleshoot-able errors.

Try to write like this:

ThisIsMyNewColumn (Internal Column Name (Shows in PowerApps etc))
This is my new column (Display Name of the above)