News and Announcements icon

Power Platform CommunityForums Power Automate - Power Automate Desktop How to add on addition...

Power Automate - Power Automate Desktop

Answered

How to add on additional data into another column within For Each loop?

Like (2) Share

Report

Report

Posted on 15 Aug 2024 04:14:50 by foxngn84

95

Hi All,

Currently I built a flow by comparing 2 list & get the differences values between it.

Once I got it, i will need to add in to an existing list.

But with the different value add-on, i would like to add a on let say column C, for each of the different value.

I tried to run as such, but it only wrote on the first value.

Categories:

Process Advisor

All responses Img

All responses (2)

Answers Img

Answers (1)

foxngn84 95 on 15 Aug 2024 at 07:23:24

Like (1)

Report

How to add on additional data into another column within For Each loop?

Agnius Bartninkas ,

Thanks a lot for your solution, It works !
Verified answer

Agnius Bartninkas 10,045 Most Valuable Professional on 15 Aug 2024 at 04:27:19

Like (2)

Report
How to add on additional data into another column within For Each loop?

It is actually writing for each entry in the list, but in line 38 you're writing a list variable, which automatically populates all values, whereas in line 39 you're writing a single string, which only populates a single cell. Since you always write it to the same row, it just keeps overwriting the previous value, and you only get one cell populated.

My suggestion is to do this:

Move line 38 out of the loop - when writing a list, you don't need to do it in a loop. It's enough to write it once.

Add an Increase variable action inside the loop (like the disabled one in line 40), but keep incrementing %FirstFreeRow2%. This will increase the row index in each iteration, and you'll be able to write the checkbox in a new cell for each item in the list.

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Replay: Power Platform Community AMA - Copilot Studio | April

Welcome to the Power Platform Communities

Quick Links

Leaderboard

#1

WarrenBelz 146,660 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 66,004 Most Valuable Professional

Leaderboard

Featured topics

Flows are not visible for users who sign in with their personal accounts

List of actions cheat sheet for Power Automate Desktop

Product updates

Microsoft Power Platform Community release plans