Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities - Lets Get Started!
News and Announcements icon
Community site session details

Community site session details

Session Id : BGiLko3v5UwPeh/d+DsFrU
Power Platform Community / Forums / 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) ShareShare
ReportReport
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
  • foxngn84 Profile Picture
    foxngn84 95 on 15 Aug 2024 at 07:23:24
    How to add on additional data into another column within For Each loop?
     
    Thanks a lot for your solution, It works !
  • Verified answer
    Agnius Bartninkas Profile Picture
    Agnius Bartninkas 10,045 Most Valuable Professional on 15 Aug 2024 at 04:27:19
    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:
    1. 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.
    2. 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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities - Lets Get Started!

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Power Automate Desktop

#1
eetuRobo Profile Picture

eetuRobo 60 Super User 2025 Season 1

#2
Nived_Nambiar Profile Picture

Nived_Nambiar 18 Super User 2025 Season 1

#3
CU12050101-0 Profile Picture

CU12050101-0 12

Overall 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