Forum Discussion
Removing certain characters in SharePoint list
Hi I have a list here which will un-avoidably have the question mark in a diamond symbol wherever the payment is printed. The payment figure and symbol can appear in any of the Remit columns shown here. Remit 1 - 7.
Is there anyway that SharePoint can remove these automatically when they appear in my list?
Thanks!
DevHuws How you are adding data in this SharePoint list? Manually typing or copying from somewhere or adding it programmatically (Power Apps/Power Automate/PowerShell, etc.)?
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs
- The data is programmatically uploaded from a Excel file using power automate. This excel is created and populated within the flow before uploading to SharePoint list therefore I don't know of any way I can alter it to remove these symbols before it reaches SharePoint.
Thanks!DevHuws Try using expression with string() function while adding data to SharePoint list:
string('your text')Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs
