web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Sharepoint field conve...
Power Apps
Unanswered

Sharepoint field converting apostrophe to ' instead of '; causing failure in PowerApp gallery

(0) ShareShare
ReportReport
Posted on by 99

I have an app that is set to display the users name and base the gallery options on who is logged in.  It's worked fine until now that I have a person who has an apostrophe in her last name.  It's O'Quinn and in sharepoint it looks like O'Quinn so the gallery will not display any results.  How do I fix this??

 

TammyGarris_0-1661176388290.png

 

TammyGarris_1-1661176433720.png

 

Categories:
  • v-jefferni Profile Picture
    Microsoft Employee on at

    Hi @TammyGarris ,

     

    If you would like to resolve this issue permanently so this list can be used as a main data source of the App elsewhere, you need to figure out why apostrophes are replaced by the an HTML number "'". So, is this list generated by importing from other sources? Have you tried to manually typing in in the list and check if apostrophe still replaces automatically? In addition, you can try and create a new single line of text column, typing in the apostrophe and see if there is any difference. These will help you find out if there are special settings of this list.

     

    Best regards,

  • TammyGarris Profile Picture
    99 on at

    Creating a new line didn't work.  Manually typing in doesn't fix it.  I did import the file from excel.

  • WarrenBelz Profile Picture
    156,566 Most Valuable Professional on at

    @TammyGarris ,

    I am not sure if this helps, but I have given up on that one - I now have OSullivan and ONeill on staff and they have simply got used to it. It also causes problems beyond what you have. 

  • TammyGarris Profile Picture
    99 on at

    As much as OQuinn and ONeil would be fine personally, the conflict is that the email system won't recognize it without the apostrophe. 😞

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 381 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 340

#3
WarrenBelz Profile Picture

WarrenBelz 187 Most Valuable Professional

Last 30 days Overall leaderboard