Hi everyone,
We're working with a Microsoft Forms to capture answers on Likertquestions. These answers should go to a SharePoint list.
However, and here gets the difficult part, we have 4 answers in those Likert questions, namely 0-1-2-3. Only if a user chooses 2-3 the answer should be registered to the list (1). Above that, the label of those likert option should be an extra choice field in a column in the SharePoint list (2) (the SharePoint column is already marked as 'multiple choices possible' and 'manually added choices').
So for example we have a question: "How good do you know the following items"
item x: 0-1-2-3
item y: 0-1-2-3
item z: 0-1-2-3
The user fills in 0-2-3, that means that only item y and z should be added as an extra choice in the SharePoint column.
We can't seem to add multiple choices to the column via the Power Automate flow... Can you guys help us?