Hi,
I have a form that has many text, single choice and multi choice fields. I want to pull the data from that form and use it to create items in a SharePoint list. No problem for text fields but I do not want the commas, quotes and brackets to be part of the choice fields.
I have spent many hours researching how to do this and i finally found a solution that works. The problem is that there are numerous steps involved just to create one multi choice item. This seems convoluted to me so i am wondering if I am going about this in the wrong way.
My question is: what is the current, best practice, way to create numerous choice items in a SharePoint list?
Here is my current flow. It works in that there are no commas or brackets in the resulting field but there are many steps involved in getting the result.
Step 1: When a new form is submitted
Step 2: Get response details
Step 3:
The long string is the ID for the multi choice field
Step 4:
Step 5:
Step 6:
The Outputs for "apply to each" are the outputs from the second compose action
Step 7: is the Create and item action which sets the multi choice field to the "DMB" variable
Is there a better way to do this for a form with many choice fields?
Thanks very much,
Cynthia
