SharePoint Integration

Re: ticked checkboxes return a 'no' value in sharepoint list

Kenny — Thu, 20 Sep 2018 08:28:20 GMT

I'm also using O365 Online, have asked a fellow colleague to test in our SP farm to see if it's replicated..

Re: ticked checkboxes return a 'no' value in sharepoint list

Hilary Stoupa — Wed, 19 Sep 2018 15:05:24 GMT

I'm using Office 365 instead of an on-prem server, but can't replicate this. I have a list with a lot of different column types - I added two Y/N fields. I customized in InfoPath, and my checkboxes worked as anticipated.

Re: ticked checkboxes return a 'no' value in sharepoint list

Kenny — Wed, 19 Sep 2018 08:18:34 GMT

Yes, exactly the same but I started again with a new list in case there was a bug in the original list but added identical columns to the original.

Apart from the 2 check boxes almost all are single line text boxes, there is also a choice field and a text box. Nothing fancy going on. I also removed the 'required' option for any fields that had them but it made no difference.

Screenshot of SP list attached.

So it seems like check boxes work in a very simple form but not when more fields are added? Can you replicate this?

Re: ticked checkboxes return a 'no' value in sharepoint list

Hilary Stoupa — Tue, 18 Sep 2018 21:18:36 GMT

And your new form used the same list & columns?

Re: ticked checkboxes return a 'no' value in sharepoint list

Kenny — Tue, 18 Sep 2018 15:24:56 GMT

I created a very simple new form with a two checkboxes and it worked fine, returned yes for checked no for unchecked.

However, then I went back and recreated a new version of the original form with all the other fields and when I tested it the check boxes no longer worked - returned value 'no' every time.

Re: ticked checkboxes return a 'no' value in sharepoint list

Hilary Stoupa — Tue, 18 Sep 2018 15:17:22 GMT

Yah, I'd try that next and see if the form correctly updates those fields on submit.

Re: ticked checkboxes return a 'no' value in sharepoint list

Kenny — Tue, 18 Sep 2018 09:34:06 GMT

Hi, I have tried refreshing the fields, saving and republishing but it hasn't changed anything. There are no workflows or rules on this form yet, its just a basic list form connected to a sharepoint 2013 list.

I will try recreating a new form from the list and see if the issue happens again..

Re: ticked checkboxes return a 'no' value in sharepoint list

Hilary Stoupa — Mon, 17 Sep 2018 15:58:31 GMT

That's really odd. Form looks fine. Maybe try refreshing the fields (see screenshot)? There isn't any workflow on the list that might be changing these?

Re: ticked checkboxes return a 'no' value in sharepoint list

Kenny — Mon, 17 Sep 2018 15:18:57 GMT

yes the other fields update fine, it's just the checkboxes where I seem to have an issue, it always just says 'no' for those.

Re: ticked checkboxes return a 'no' value in sharepoint list

Hilary Stoupa — Mon, 17 Sep 2018 15:15:14 GMT

Ok, I can probably help with that too. When you submit the form, all values are updated except the fields associated w/ the checkboxes?

Re: ticked checkboxes return a 'no' value in sharepoint list

Kenny — Mon, 17 Sep 2018 15:06:55 GMT

Thank you. I have attached the form just now.

Also - you explained this to me months back but I cannot work out how it was done again or find your answer, sorry! When a user selects a school from the drop-down I want the named person to pre-populate from another sharepoint list.

Re: ticked checkboxes return a 'no' value in sharepoint list

Hilary Stoupa — Mon, 17 Sep 2018 15:00:01 GMT

I'd be happy to take a quick look at your form if you want to attach it to a reply (under the Options tab)

Re: ticked checkboxes return a 'no' value in sharepoint list

Kenny — Mon, 17 Sep 2018 14:54:25 GMT

Hi, yes this is a SharePoint list form.

When I drag the check boxes in and change the controls it reads 'false'.

In the SharePoint list - I have two columns both are yes/no (checkbox) types defaulting as no. However whatever I do in the form - tick or don't tick, the data always shows 'no' in the sharepoint list. It's like the data is not being communicated between the two systems somehow....

Re: ticked checkboxes return a 'no' value in sharepoint list

Hilary Stoupa — Fri, 14 Sep 2018 23:19:17 GMT

So this is a list form? I'd check the properties on the checkbox controls, first. I'd also drag the data fields that are bound to the checkboxes onto the form, and change the control to text boxes or calculated values so I could see the actual data value of the field....

ticked checkboxes return a 'no' value in sharepoint list

Kenny — Tue, 11 Sep 2018 15:32:45 GMT

Hi,

I have a form with 2 checkboxes which are unticked by default. This form feeds data to a sharepoint 2013 list. I expected the value in sharepoint to be 'yes' when the checkboxes are clicked but no matter what I do, they always return as 'No'.

Why does this happen and how can I fix this?

Thanks

Kenny