Answered

Need to remove 'Apply to each' or work around it

Like (0) Share

Report

Posted on 23 Jan 2020 18:19:04 by rburns05

I've set up an automated flow that initiates 'When an item is created' in a SharePoint list, which I'll refer to as List 1.

The action I've added is to 'Create Item' in a separate list, which I'll refer to as List 2.
There’s a Choice field in List 1 labeled ‘Data Retrieval/Sourcing.’ The list allows for multiple selections in this field. I’d like to have the responses to this field populate into a separately named field in List 2 labeled ‘Customer Data Requirements.’ ‘Customer Data Requirements’ is a multiple line text field. If someone selected multiple options on the ‘Data Retrieval/Sourcing’ question, I would expect that they would appear one after the other, possibly separated by a comma in ‘Customer Data Requirements’ if the flow worked as I intended.

When I went to add ‘Data Retrieval Sourcing’ as dynamic content to the ‘Customer Data Requirements’ field in List 2, an Apply to Each box overlapped the entire ‘Create Item’ space I was working within. I’m not familiar with this feature but it only appears when I insert a multi-choice field as dynamic content into another field. I’m not interested in using it and I’d like to find a way to work around it if there’s no way to remove it entirely.
When I saved the flow and submitted an entry with two distinct choices on ‘Data Retrieval/Sourcing,’ two entries were created in List 2 with the same ID. The only difference, as you might guess, were the responses to the ‘Data Retrieval/Sourcing’ question. The responses were separated out, not joined together in one entry as I intended.

I think my options are to 1) somehow figure out how to remove ‘Apply to Each’ from appearing or 2) figure out how to work around ‘Apply to Each’ so that I get the intended result of combining the responses from the multi-choice fields into one entry. I should also note that the ‘Data Retrieval/Sourcing’ field isn’t the only multi-choice one I’m working with, so I’d need to be able to create a solution which would work for other list fields with the same column type as well.
Any advice or help would be appreciated.

I have the same question (0)

Summarized by AI

All responses (5)

Answers (2)

Ed Gonzales 4,531 Most Valuable Professional on 23 Jan 2020 at 18:49:36

Like (0)

Report

Re: Need to remove 'Apply to each' or work around it

@rburns05

Hi there. Check out this video from Elaiza Benitez, I think it might help.

Keep us posted.

-Ed-

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Was this reply helpful? Yes No
rburns05 7 on 23 Jan 2020 at 19:44:39

Like (0)

Report

Re: Need to remove 'Apply to each' or work around it

Thank you for your response. Unfortunately, I wasn't able to make the connection between the video and the issue I'm experiencing. I'll keep re-watching/retrying but I haven't had any luck so far

Was this reply helpful? Yes No
Verified answer

RobElliott 10,284 Super User 2025 Season 2 on 23 Jan 2020 at 21:25:49

Like (1)

Report
Re: Need to remove 'Apply to each' or work around it

@rburns05 you can do this as follows. First we have list 1 with a column named Data Retrieval/Sourcing which is a Choice column allowing multiple selections:

In the flow the SharePoint trigger is When a new item is created.

The first action is to initialize a string variable.

Next we need to add a Parse JSON action. We need this because the Choice column gets brought into the flow as an object with lots of other info. We don't want that other info, we just want the value property formatted as a string:

The syntax for the JSON code is:

{ "type": "array", "items": { "type": "object", "properties": { "Value": { "type": "string" } }, "required": [ "Value" ] } }

We then add an append to string variable and select Value from the Parse JSON section of the dynamic content. Add a space after Value.

It will wrap it in an apply to each but don't worry about that, it's expected.

Finally, the new item is created in List 2 and the Customer Data Requirements column is populated by the variable.

The result in List 2 is that only 1 item is created and the items are separated by the space you added earlier.

Come back with any questions about this.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on 24 Jan 2020 at 05:33:30

Like (0)

Report

Re: Need to remove 'Apply to each' or work around it

Hi @rburns05 ,

Please try to refer to the following method to configure Flow.

Best Regards,

Was this reply helpful? Yes No
rburns05 7 on 24 Jan 2020 at 13:34:41

Like (0)

Report

Re: Need to remove 'Apply to each' or work around it

This worked perfectly and was exactly what I needed. Thank you!

Was this reply helpful? Yes No