How to add values in SharePoint List Column of type "Yes/No"

[pankaj.chaturvedi_ACL (Pankaj Chaturvedi)]

Hello All,

I have a SharePoint list to add item too. I am able to add values to all other columns and they’re mostly string types.
However, I also have a column of type “Yes/No” and I am unable to push value into that column using studio.

I am using Microsoft 365 package dependency and activity is “Add List Item”.

Can anyone help on how to push value to a sharepoint list column of type “Yes/No” ?

[adi.mehare (Aditya Mehare)]

try below activity

Activities - Update Single List Item

[pankaj.chaturvedi_ACL (Pankaj Chaturvedi)]

No, it does not solve the problem of pushing a value into a “Yes/No” column in a SP List thru Studio.

[SorenB]

Hello @pankaj.chaturvedi_ACL

Have you tried predefining the DataRow and using Boolean type variable for the specific (Yes/No) column?

Regards
Soren

[pankaj.chaturvedi_ACL (Pankaj Chaturvedi)]

Yes @SorenB

I did try to that but somehow the list won’t accept Boolean format. It gives error when I try to use Boolean for this column says some invalid format.

Regards

[sonaliaggarwal47 (Sonali Aggarwal)]

Hi @pankaj.chaturvedi_ACL,

In that case, you would require to contact SharePoint owner/manager of that list and you can get its column settings updated.

Or when you push the Boolean value, you can convert it into a string format before pushing the same.

That should work.

Regards
Sonali