cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
emuelle
Level: Power Up

Text error with punctuation

Hello, 

I'm new to powerapps. I've built an app using data from a sharepoint list. For some reason when there is certain punctuation in the text from the sharepoint list I'm getting strange errors when connected to powerapps. See below in red:

 

Program Quality and Capacity: Program or Model Implementation Consulting

Both agency level and system level technical assistance is included. 

 

Is there any way to fix this?

Thanks in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Text error with punctuation

Hi emuelle,

 

Those look like HTML character codes - : is a colon,   is a non-breaking whitespace character.

 

Some questions:

  • Is that the actual data in the sharepoint list, or what PowerApps is showing?
  • Is the SharePoint column plain text or HTML?
  • Are you getting actual errors, or just those codes in your output?

Some screenshots might help 🙂

 

Something you might want to try is put the output into an HTMLText() control.
There is a PlainText() function that converts to plain text, but if it doesn't understand the code it just removes it, which may not be what you're looking for.

 

Kind regards,


RT

View solution in original post

1 REPLY 1
Super User
Super User

Re: Text error with punctuation

Hi emuelle,

 

Those look like HTML character codes - : is a colon,   is a non-breaking whitespace character.

 

Some questions:

  • Is that the actual data in the sharepoint list, or what PowerApps is showing?
  • Is the SharePoint column plain text or HTML?
  • Are you getting actual errors, or just those codes in your output?

Some screenshots might help 🙂

 

Something you might want to try is put the output into an HTMLText() control.
There is a PlainText() function that converts to plain text, but if it doesn't understand the code it just removes it, which may not be what you're looking for.

 

Kind regards,


RT

View solution in original post

Helpful resources

Announcements
thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,161)