Hi All,
I have been looking and searching for answers to this problem all day and I've finally cracked. I need to admit to needing some help!
I am having issues with getting multiple choice answers to display properly within a SharePoint List when I am pulling it through with Power Automate after collecting via a Form.
The results are pulling through as [Answer 1, Answer 2, Answer 3]. This then messes up the filter with the choices pulling through in a block (e.g. rather than my able to filter for those who answer with "Answer 1", I can only pull through the full [Answer 1, Answer 2, Answer 3]. I am guessing I have missed something somewhere along the lines with regards to formatting of columns.
Does anyone have any ideas what I can look into here please?
Thank you!
I have been looking and searching for answers to this problem all day and I've finally cracked. I need to admit to needing some help!
I am having issues with getting multiple choice answers to display properly within a SharePoint List when I am pulling it through with Power Automate after collecting via a Form.
The results are pulling through as [Answer 1, Answer 2, Answer 3]. This then messes up the filter with the choices pulling through in a block (e.g. rather than my able to filter for those who answer with "Answer 1", I can only pull through the full [Answer 1, Answer 2, Answer 3]. I am guessing I have missed something somewhere along the lines with regards to formatting of columns.
Does anyone have any ideas what I can look into here please?
Thank you!
