Forum Discussion
Solved
Getting wrong data from a Sharepoint list (calculated field)
Hi everyone, I'm getting a strange situation with PB Desktop. I hope someone could give me an advice. I'm trying to get data from a sharepoint list that has a calculated field (sum of two numbers...
I can reproduce your issue in my side with portuguese regional settings.
Change your source to:
= OData.Feed("https://NAME.sharepoint.com/sites/NAME/_vti_bin/listdata.svc")change only your link, you need the:
/_vti_bin/listdata.svc
Using OData.Feed you will get what you want.
Hi kastorsky,
Maybe because of your regional settings. In sharepoint you use dots or comma to decimal numbers? If not try to use ROUND in your formula.
I thought it was that but I'm using integer not decimal number... So I've already changed my PB to use dots as my sharepoint and also I've tryed the ROUND but nothing happens. The PB receive the value as thousands.
I can reproduce your issue in my side with portuguese regional settings.
Change your source to:
= OData.Feed("https://NAME.sharepoint.com/sites/NAME/_vti_bin/listdata.svc")change only your link, you need the:
/_vti_bin/listdata.svc
Using OData.Feed you will get what you want.