Hi,
I have an app form which saves responses to a sharepoint list using the patch function. Each question response get’s it’s own line.
So the user can leave and come back, at the start of a new session it retrieves all the records for that persons session and saves them in a collection to which the Default property of the fields is set to the corresponding entry in the collection.
This is going well until I have come to our combo boxes where multiple selections are allowed. To save the values into SharePoint, the selected values are concatenated together separated by a “; “ so they have one line in the SharePoint list.
To do the prefill on return I want somehow split up these values again on the DefaultSelectedValues property however, I can’t work out how to do it.
Initially I had the function:
Split(LookUp(CollectAnswers, question_id = 216, answer),"; ")
But while it says this is a valid function it doesn’t produce any results. I’m now thinking I need to do some look up of these values with the original list feeding the combo box but can’t for the life of me figure out how.
Any help would be greatly appreciated
