How can I use values from an array to update columns?

(0) Share

Report

Posted on by SteveMForm

118

Hi Folks

still looking for a solution for the following:

I have a multi-choice form question with 8 possible choices as a required answer and I have created an array from. The below shows that this response got 2 choices selected:

I now need the flow to take the output from Select BA Service and using the Create Item to update any of the 8 SharePoint columns with a Yes or No as they are Yes/No column types:

The above is a view of the Create Item control and the 8 fields to indicate whether a Yes or No is needed (I assume each of these will need to have an output from further up in the flow).

Help much needed

Thanks

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

ManishSolanki 15,089 Super User 2025 Season 2 on at

Like (1)

Report
Re: How can I use values from an array to update columns?

Hi @SteveMForm

Here is the sample flow.

I have created a sample list with two yes/no columns: Vision Development & Options Development.

Flow:

I have used compose action to store the values of multi Seclect choice field as an array:

[
"Vision Development",
"Options Development"
]

In Create item action, we will be using expression to check if input array contains a specific word and then set the columns as Yes or No.

if(contains(outputs('Compose'),'Vision Development'),true,false)

Expression used for 'Options Development' column:

if(contains(outputs('Compose'),'Options Development'),true,false)

This way you can set Yes/No value for other fields. You don't need select action as we need only array with multi values.

Output:

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
SteveMForm 118 on at

Like (0)

Report

Re: How can I use values from an array to update columns?

Hi @ManishSolanki - Genius! So simple but works a treat!

I owe you a beer or coffee!

Kudos

Steve

Was this reply helpful? Yes No