cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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 !!! 

4 REPLIES 4
Highlighted
Anonymous
Not applicable

Re: How to show all spaces in a String

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

space1.JPG

 

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

space2.JPG

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

space3.JPG

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

Highlighted
Frequent Visitor

Re: How to show all spaces in a String

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~

Highlighted
Anonymous
Not applicable

Re: How to show all spaces in a String

Put is as a development suggestion?

 

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

 

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

Highlighted
Frequent Visitor

Re: How to show all spaces in a String

Already done.

Thanks for suggestion

Welcome to vote

Helpful resources

Announcements
secondImage

New Return to Workplace

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

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Users online (4,206)