Seems to be a problem with "number" columns in sharepoint, possibly due to regional settings
SharePoint list create item is the action I'm having problems with
Formatting error on the following input bodies:
1 using float() to provide a number:
"NOM_DIAM": 0.5,
"message": "Input string was not in a correct format."
This is strange, because if I use flow to get items from the same list the output representing the column looks like this:
"NOM_DIAM":0.5,
2 I also tried converting it to a string:
"NOM_DIAM": "0.5",
"Input string was not in a correct format.
3 just for "fun" i wanted to see if there was some regional issue and replaced "." with ",".
(I have to use "," and get a "numbers only" error if try using ".", when inputting decimals in the sharepoint webui for the list):
"NOM_DIAM": "0,5",
"Input string was not in a correct format."
The column is a number column with 2 decimals in the settings for the column. What is the correct way to provide decimal values into sharepoint list item number columns using flow? Is there a way to work around this besides changing the column into a text-column?
The regional setting for the sharepoint site is Norwegian, and I don't dare change this to english because this will create other issues. In any case, I don't see why I should need to do something like that, a value have nothing to do with formatting of that value does it? Wouldn't otherwise be the same as saying a word displayed in Times New Roman has a different meaning if it was Arial?
Why can't sharepoint list just use traditional types instead? I guess they wanted to simplify, but right now I fail to see how it has become simple..