Answered

Need Help with Comparing Microsoft Forms Responses to JSON Array (key value)

(0) Share

Report

Posted on by javieracortes04

Hello, I need some help.

My flow starts with the Trigger "When a new response is submitted", because I'm using Microsoft Forms. After that, it has an action called "Get response items".

Then I Initialize a variable called "pregunta" (a string) that saves an answer from the Forms.

Captura de pantalla 2023-10-16 163411.png

The thing is, this answer can be 6 options, Option A to Option F (these are just examples, names are in Spanish).
Each Option is assigned to a number, so: Option A = 1, Option B = 2, Option C = 3, and so on.

(variable "numeroPregunta is 10, just because, to initialize it)

Captura de pantalla 2023-10-16 163826.png

Chat GPT gave me this code for the Compose Action.

if(equals(variables('pregunta'),variables('jsonPreguntas').jsonPregunta),variables('jsonPreguntas').jsonNumeroPregunta)

But it's not working.

Do you know how I can do this?

Variable = "Cat"

[

{"pet": "dog",

"color": "black"},

{"pet": "cat",

"color": "orange"},

"pet": "mouse",

"color": "white"}

]

new Variable = orange

I need to obtain the other parameters that match with my variable.

Maybe I'm not using the json array correctly or something.

Please, I would appreciate your help!

Categories:

General topics

All responses (4)

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @javieracortes04 ,

I've made a test for your reference:

1\The Form

2\My flow

3\Result

Best Regards,

Bof
javieracortes04 7 on at

Like
a
(0)

Report
Copy link

Link copied!

First of all, thank you.
But I think I didn't explain myself so well. So sorry!

I need to "transform" the answer to an equivalent index. If the answer was Cat, then I need the variable set to 1. If the answer is Dog then variable = 2, and so on.

I need to do this with 2 questions, the first one has 6 options, but the second one has 41 options, so I hope the answer to my problem is not booleans or parallel branches.

Best regards,
Javiera
Verified answer

Chriddle 8,729 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
These transformations can bedone with simple objects.

Here an example flow where the trigger input is transformed to the according number:

"Test" Input:

outputs('Transformation')[triggerBody()['text']]

The flow run looks like this:
javieracortes04 7 on at

Like
a
(0)

Report
Copy link

Link copied!

It did work!

Thank you so much!