Mar 14 2023 05:03 AM
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!
Mar 14 2023 05:28 AM
@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
Mar 14 2023 05:48 AM
Mar 14 2023 06:26 AM
@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
Mar 14 2023 06:50 AM
Mar 14 2023 07:04 AM
Mar 14 2023 07:07 AM
@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
Mar 14 2023 07:09 AM
Mar 14 2023 07:09 AM
Mar 14 2023 07:12 AM
@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
Mar 14 2023 07:35 AM
@DevHuws Great, glad it worked for you!
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
Mar 15 2023 02:12 AM
Mar 15 2023 03:50 AM
@DevHuws We are using JSON column formatting to hide the character in list view which only customizes the display of list data. It does not remove/hide the character from underlying column value.
That's why you are seeing this character in word document. Hence earlier I was suggesting you to remove this character from its source itself from Power automate flow or excel or from where you are pulling this data.
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