Forum Discussion

DevHuws's avatar
DevHuws
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...
admin
developer
microsoft lists
SharePoint Online
DevHuws's avatar
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's avatar
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's avatar
    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
    • ganeshsanap's avatar
      ganeshsanap
      MVP
      Mar 14, 2023

      DevHuws How you are creating and populating excel file withing Power automate flow? From where this data is coming to excel file?

       

      Maybe you can check Power automate flow and see the source of this unwanted character and remove it from there.

      Or you can try using JSON column formatting like: 

       

      {
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "=replaceAll(@currentField, '�', '')"
}

      Reference: SharePoint: Replace All Occurrences of Substring in a String using JSON Formatting 

       

      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

      • ganeshsanap's avatar
        ganeshsanap
        MVP
        Mar 14, 2023

        DevHuws Here are before / after results after using JSON column formatting:

        Before: 

        After: 

        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's avatar
      DevHuws
      Copper Contributor
      Mar 14, 2023
      How would this expression look in power automate?

Resources