Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

How to show all spaces in a String

Hello Everyone:


Currently I met a problem when develop my application,In mysql database, the value of  one column has 2 spaces in the middle

of string, but When I  use gallery to select this record , I found that  1 space was missing, So how should I show all the  spaces

in the middle of string?


All the function I found is how to delete spaces......


Thanks !!! 

Not applicable

it would appear that MS automatically strips out additional spaces when displaying data - and not just in PowerApps.


I set up a quick Sharepoint List and added some text with single, double and triple spacing in it.


PA shows then all with single spacing



Then, when looking at the same list in Sharepoint, I get the same single space...


However, when editing in Sharepoint, the true spacing is shown...


So, I suspect his is one of those lovely Microsoft "Features"...and you're stuck with single spacing. 😞

Frequent Visitor

WOW, Thanks for your answer and test !


Personally I like this lovely feature of Microsoft, but in my case , there is no solution for that ?

Hope there will be a developer of PowerApps show up and help me out~

Not applicable

Put is as a development suggestion?


A "show as true" attribute on the text field perhaps?

Frequent Visitor

Already done.

Thanks for suggestion

Welcome to vote

Helpful resources

PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (927)