Appending to SharePoint List/Selecting multiple items from a field

[jdemeyer]

Greetings!

I'm attempting to append an item to a SharePoint list.  One of the fields in the item is a list of states and multiple states can be selected.

When I add an item with one state, the item is successfully added.  When I attempt to add an item with two states, the list of states show no selections in the new item.

Adding One State (successful)

I assign the name of the state to the field.  For example, Ohio.

Adding Two States (no states selected)

I tried state names separated by a comma (Ohio,Illinois) and each state surrounded by the HTML paragraph tag (<p>state name</p>).

Thoughts on how I might convey the selection of two items in the list?

Thanks!

Joe

[gautiergodard · Accepted solution]

Hello @jdemeyer 

Adding values to SharePoint can sometimes be a bit tricky, however in my experience this is typically based on how the field is configured in SharePoint. Are you receiving any error when trying to append your data?

- Using a SharePoint List input tool, could you please provide a sample of a row in your data where multiple states are selected?

- Additionally, could you please confirm all possible state values included in the list - the reason I ask is because if you are trying to write a value that doesn't exist as a value in your SharePoint list, this could cause a problem.

As a simple alternative, try using a semi-colon (;) instead of a comma.

[jdemeyer]

Hello @gautiergodard !

Thanks for the quick reply!

I was not getting any errors.  It appeared SharePoint ignored my attempts.  I'm curious to check the field configuration and will remember to try that if I have more issues.

When I used a semi-colon to separate the states, SharePoint accepted that and two state were selected.  Very cool and thanks!

Joe