Feb 12 2020 05:25 PM
To give some background, I have set up a SharePoint List to track part numbers that need to be cycle counted in our Manufacturing facility. I recently the site to the new version of Sharepoint and now my part numbers show up in an unwanted format. For example, a part number that used to show up as "5456226-599" now looks shows up as "1001_.000". I entered in the below JSON and it appears to fix the issue when I select the "Preview" button. However, After I save and close out of the formatting window, the part number column goes back to the unwanted format.
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"txtContent": "@currentField"
}
Feb 13 2020 01:36 AM
@Rmkemmi does the default value of the single line of text column have a default value using a formula or anything?
Rob
Los Gallardos
Microsoft Power Automate Community Super User
Feb 13 2020 10:23 AM
@RobElliott There is no formula - I believe the default value for the part number is just entered in plain text. Many of the part number do have dashes (e.g. 11-000-39), so I don't know if that would have an impact?
Feb 13 2020 12:30 PM - edited Feb 13 2020 12:35 PM
@Rmkemmi sorry, all I can suggest is that you create a new column, add in the data and see if the same thing happens. Without seeing it in action I don't know why the data would be being changed.
Rob
Feb 13 2020 12:42 PM