Answered

ADD SEVERAL VALUE ON ONE VALUE

(0) Share

Report

Posted on by Ame-18

Hello,

I have created a flow related to a form and I would like to add this form to a SharePoint list if certain conditions are met.

In my form there is a choice question with more than 100 choices in it.

I would like to add several values to an value.
For example: If person A chooses value 1 and person B chooses value 2, I would like one of the two values to be chosen to create the SharePoint list.

However in my flow there are not only 2 values, there are more than 30 values.

So I would like to add several values by creating a condition :
The multiple choice question] contains [one of the 30 values].

Categories:

Building flows

All responses (3)

Answers (1)

Sort by

v-litu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Ame-18,

You could initialize an array variable, then use rand() function to generate an array contains 1 to 30.

Then put the array into the left side of Condition action, for example, the below screenshot is checking if the array contains "2":

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ame-18 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-litu-msft

Thanks for your response !

However, I think there was a misunderstanding about my request.
It is not numbers that I would like to add, but text.

To make it simpler I would like that when a person chose "text 1" or "text 2" or "text 3" etc.. in the forms to add this response on a specific SharePoint List.

I know how to create a sharepoint list. But I wanted to know if it was possible to add several values in one condition.
I can't add the value one by one because there are too many of them and I reach the limit to add condition.

Thanks 🙂
Verified answer

v-litu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Ame-18,

You could use the logical comparison function instead of Condition action, for example:

or(contains(variables('Collection'),'text1'),contains(variables('Collection'),'text2'))

logical-comparison-functions

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.