Unanswered

Apply to each/ apply to each 2/ apply to each 3 keeps populating

(1) Share

Report

Posted on by BB818U

Hello,

I am trying to move/or copy data from one SharePoint list to another, I have already cloned list A columns to list B columns but now I need the flow to move the data from the list over but when I test the flow it does not work and I don't know why. I go into power automate.

1. Use cloud flow

2. Manually trigger flow

3. Get items

4. Create items

One I create items. I select each option but the columns that have multiple items create an "APPLY TO EACH" then the next column with multiple option says APPLY TO EACH 2/ THEN APPLY TO EACH 3 AND 4. Not sure why its not working but when i text the flow it fails.. Please help

Categories:

Building flows

I have the same question (0)

All responses (20)

Answers (2)

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (2)

Report

@BB818U It would help if you could upload screenshots of your flow. The information you've provided isn't sufficient to help troubleshoot your issue.

Was this reply helpful? Yes No
BB818U on at

Like (1)

Report

Uploads belowthe errori dont know if i need to select each column with the word value at the end or just the column name

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

@BB818U The reason the flow is nesting Apply to Each action is due to the Market Value - 1 Column. That column is a multi-choice column field. Multi-choice columns return values in an array.

EDIT: You need to use a Select action to pull the values of the multi-choice column and use that instead.

Hope this helps!
If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉Watch my tutorials on YouTube
👉Tips and Tricks on TikTok

Was this reply helpful? Yes No
BB818U on at

Like (0)

Report

Thank you, I will retry now, does all items that have multiple choice fields need to be done the same way?

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

@BB818U Sorry I made an error in my earlier response.
Select Action
You will need to add a Select action to your flow. In the From field, insert the multi-choice dynamic content. In Key field, insert Value and in the Value field, insert the multi-choice value dynamic content.

The Select action will pull just the values into an array which is what the Create Item action requires.
Insert Multi-Choice Values
Add a Create Item action after the Select action.

In the Create item action. Click on the icon to switch the input mode for the multi-choice column.
Insert the output dynamic content from the Select action.

Run a test.

Tip: You can limit the number of items to run your test with by using the Top Count in the Get Items action. This way you aren't running the test on your full list.

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉Watch my tutorials on YouTube
👉Tips and Tricks on TikTok

Was this reply helpful? Yes No
BB818U on at

Like (0)

Report

Ok I am getting close all the data moved. Test succeeded, but the "MARKET COLUMN. "In the SharePoint list is not formatted correctly. I did enter the SELECT action, but do I need to add that action in a specific order?

I'm not seeing the "OUTPUT" button in dynamic flow this is my issue now

I have about 17 choices in the market column within the list

Was this reply helpful? Yes No
BB818U on at

Like (0)

Report

Hello can you view my message above this one, I am very close. That one column is the issue

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

@BB818U Have you tried what I suggested on Friday? You'll need to use a Select action.

Was this reply helpful? Yes No
BB818U on at

Like (0)

Report

Yes, I did the select option it looks like this, but under market value, the output purple option in the dynamic content does not pop up, im sure the select option is where i am having the error. At the Insert Multi-Choice Values

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

@BB818U The create item action must be placed AFTER the select action since you will be using the Select action output in the Create item action. By placing the Select action after the Create Item action (the way you have it now) you will not be able to access the Select action output in the Create item action. Sorry if that wasn't clear in my prev post I will update the screenshot.

Was this reply helpful? Yes No