Forum Discussion

Copper Contributor

Mar 14, 2023

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 he...

MVP

Mar 14, 2023

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

DevHuws
Copper Contributor
Mar 14, 2023
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!
- ganeshsanap
  MVP
  Mar 14, 2023
  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
  - DevHuws
    Copper Contributor
    Mar 14, 2023
    Inside of the "Create item"?
    When choosing what is input into the cloumn?
    
    It is worth noting as well that this symbol appears in the excel too. before uploading