Unanswered

How to compare a specific field from every item on an array with a form answer?

(0) Share

Report

Posted on by mateus_oliveira

Hi!

I have an automation connected to a Microsoft Planner and a Microsoft Form in which I list all the buckets on a Planner plan, and I need to compare if the Name of the bucket is similar (equals to or contains, not an issue) to the answer given by the user on a Microsoft Form (it's a multiple choice question in which the user can select only one option).

How can I loop through all the buckets listed (I get this array of buckets using the Power Automate native connector) and compare the Name of the Bucket to the Form Answer, and then, when I get a match (or a boolean true), I define a variable with the ID of the bucket found?

I tried some things, but it seems I'm not implementing For Each + Condition > Action in the correct way...
Thank you all in advance.

Categories:

Building flows

bucketid-poweraut...

I have the same question (0)

All responses (2)

Answers (0)

wskinnermctc 6,519 Moderator on at

Like (1)

Report

Are the submissions from the MS Form actually written? Like free text?
Or will the response be from multiple choice and they can select the option? Can they select multiple options?

Was this reply helpful? Yes No
mateus_oliveira 5 on at

Like (0)

Report

It's a multiple choice answer, and the user can only select one option - but there's a "Other" option that would allow them to input a free text response. However, for this, I can have a "default" output (a default bucket for any reply whose given bucket doesn't match any on the list).

Was this reply helpful? Yes No