Skip to main content

Notifications

Community site session details

Community site session details

Session Id : M8H81kBfFHZN9D8Z3HNLJd
Power Apps - Building Power Apps
Answered

_x0020_

Like (1) ShareShare
ReportReport
Posted on 7 Aug 2017 15:31:25 by

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:
  • Warisme Profile Picture
    32 on 31 May 2022 at 01:09:10
    Re: _x0020_

    Just an FYI, so in most Functions where a true column name is required (Searches, Sortby, Filters etc)

    and you did not realize putting dashes or spaces in a name would cause you SO MUCH GRIEF LATER..

     

    To a Name like   XXX - RRRRR YYYY is not working with a function where the column name is

    supposed to be in ""    like "Title" 

    So to find the ACTUAL NAME that the list uses to ACCESS the DATA, you can bring up the 

    LIST in a Browser and then use F12 and search the code of a list for them.

    The name choices in a list are important...

     

    So when someone decides to use silly stuff like 

    "XXX - RRRRRR"

    You have to then put in "XXX_x0020__x002d__x0020_RRRRRR" in order to use it as a SOLID PROGRAM COLUMN NAME.

     

    So the x0020 is a space and the x002d is a Dash...  

     

    Moral of the story is to use UNDERSCORES for SPACES and don't use DASHES as its just bad practice, but 

    you like me may be working on a list you did not create.  Happy Programming.

     

  • Kather-pillar Profile Picture
    12 on 04 Jul 2020 at 01:54:03
    Re: _x0020_

    how do you this in the powerapps

  • alirobe Profile Picture
    30 on 19 Nov 2017 at 03:18:11
    Re: _x0020_

    This is poor design.

     

    I agree the underlying data structure needs an escaped space, but the displayed labels should un-escape automatically.

     

    I do not agree that "First rule of thumb in Ms Access, SharePoint Lists, and any table, Dont crete columns with spaces."

     

    This may be good advice for IT consultants, but PowerApps is designed for business users.

     

    Spaces will be used.

     

    PowerApps needs to deal with it the same way Access, SharePoint Lists, and Tables do: Escape in the back-end, and automatically un-escape in the front end. There is no reason why a front end user should ever see an escaped sequence. You say that Excel does not offer an unescaped label. The unescaped label is in the Excel sheet. The Excel sheet is simply XML, and the header cell value is unescaped, and visible to the excel user. So I'm afraid it's not a valid excuse. PowerApps could certainly get the value, and it could certainly display it. It simply hasn't been thought about enough.

  • Verified answer
    nickduxfield Profile Picture
    497 on 03 Sep 2017 at 08:18:49
    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)

  • Verified answer
    AndyPennell Profile Picture
    on 01 Sep 2017 at 23:27:09
    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.

  • Community Power Platform Member Profile Picture
    on 08 Aug 2017 at 15:07:13
    Re: _x0020_

    Thanks for that. It does baffle me a bit, I would've thought a bug like that would be ironed out early in the development stage of Powerapps. Spaces are kind of important in the use of language! 

  • Fields Profile Picture
    312 on 08 Aug 2017 at 10:16:27
    Re: _x0020_

    Hi there, 

     

    As at my notice, i don't think that exists. In powerapps, every single space will have the _x0020_ in there. That's why, people advice to don't use spaces or any special character in that matter.

     

    So no, there is no solution to that problem.

     

    That's something people should avoid, spaces, special characters, and Numbers as first letter.

     

    I hope i was helpfull. If you got a solution tho (That, again, i don't think it exists), feel free to share with us 🙂

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,765 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,091 Most Valuable Professional

Leaderboard