Forum Discussion
eFrogBE
Sep 18, 2023Copper Contributor
Reading Sharepoint List Item Values with Powershell gives me a value factor 10 (60 instead of 6)
Hi, I'm using Powershell & MS-Graph API to read some information from a Sharepoint List. The Sharepoint List have a Field Object_Capacity (Type : Number (1, 1.0, 100)) where I enter a value. In th...
eFrogBE
Sep 19, 2023Copper Contributor
LeonPavesic
Thanks for the feedback.
This is indeed the work around I have used in my scripts.
But there is something wrong in the Powershell MSGraph command MgSiteListItem which in my opinion should be solved.
I'll try to figger out where to escalate this to Microsoft Powershell MSGraph development team.
kurt
eFrogBE
Sep 25, 2023Copper Contributor
Hi,
I found the cause:
It look to a Regional setting Issue.
On my computers the regional setting is:
I changed it to this:
In the sharepoint list, when changing the value into 5.6 (dot) it gives me 56 in the Browser
Entering 5,6 comma) gives me 5,6 in the Browser.
Conclusing, Issue is caused by Regional setting of the computer running the script.
The Powershell Command Get-MgSiteListItem has a Regional setting issue.
Regards
Kurt