Hi, I have a multiple choice question in my form that brings the answer in an Array/String format to my Sharepoint Lists which makes it impossible to filter rows based on the customer selected choice. Customer has to select Minimum of 3 and Maximum of 5 options from the question. The data comes to list like this ["Option 1","Option 2","Option 3"]
Where as I need it like this Option 1, Option 2, Option 3 where it would enable filters automatically in sharepoint lists to filter rows based on the selected choices. I already tried Compose, Initialize Variable, Select but everything throws me error.
I have a SharePoint choice column called Features. I have allowed multiple selections for this column:
The Choice values from Microsoft Forms are plain text. I'm using a variable to demonstrate this:
The JSON function is used to convert the varChoices text into an Array. Note the properties in the Map:
When creating the item and specifying the value for the Features choice column, switch to "input entire array" then select the output of the Select action:
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Share
Report
All responses (
Answers (
11,691
