How to split my data from multiple answers answers?

(0) Share

Report

Posted on by Blqnk39

Hi all,

I've created a flow to trigger cases based on the answers from a multiple answers question in Microsoft Form.

For example, I've selected more than 1 answers and one of them is this:

{
 "name": "Training Topic",
 "value": "Service Excellence Module 2 (Session 2) | 22 September, 2PM - 5PM (MY Time)"
}

But in the following step, the switch received this:

{
 "expressionResult": "Service Excellence Module 1 (Session 2) | 20 September, 2PM - 5PM (MY Time)Service Excellence Module 2 (Session 1) | 8 September, 2PM - 5PM (MY Time)Service Excellence Module 2 (Session 2) | 22 September, 2PM - 5PM (MY Time)"
}

It seems like it's appending to the end of the variable instead of overwriting it and it will never match any of the case value I provided.

May I know how to work around this?

All responses (2)

Answers (1)

okeks 802 Super User 2024 Season 1 on at

Like (0)

Report

Re: How to split my data from multiple answers answers?

You can use the split() method to split it with a seperator, but you would need to add a unique character at the end of each option.
Verified answer

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (1)

Report

Re: How to split my data from multiple answers answers?

Hello @Blqnk39 ,

please share the detailed flow in Edit Mode.

It could be much easier if you explain the purpose of splitting the multiple choice answer in order to trigger the Case creation.

Maybe this article could help you, regardless where to write the outputs:

https://powerautomatejoy.com/2022/08/01/how-to-get-multiple-choice-responses-from-forms-and-put-them-in-sharepoint/

If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.

My blog site about Power Automate: https://powerautomatejoy.com/

BR,

Marco