Appending to SharePoint List/Selecting multiple items from a field

Question

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 (

state name

). Thoughts on how I might convey the selection of two items in the list? Thanks! Joe

gautiergodard · Accepted Answer

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.