web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Power Automate Add row...
Power Apps
Answered

Power Automate Add row to table ignores one column

(0) ShareShare
ReportReport
Posted on by 8

Hi all,

 

I am building a flow to copy a table from one exel to another excel. The table has three columns and the first and third column are processed as required. But somehow the second column is not copied and I don’t understand why. I hope someone can help me.

 

Below is the basic flow, as you can see in the Apply to each I call three columns from the excel file; Uursoort, Jaar/Week and Uren. I would therefore expect three column values in the output of each instance.

 

Joanne76_0-1679945538649.png

Below is the output from the “List rows”. Highlighted is the data from the first row, so the information in all three columns is there.

 

Joanne76_1-1679945578259.png

 

This is the output from the first instance of the “Apply to each”. As highlighted, from this step I only get the first and third column, the column Jaar/Week is not included.

 

Joanne76_2-1679945637479.png

 Does anyone know how to correct this so I get all three columns in the output?

 

Thanks, Joanne

 

Categories:
  • Verified answer
    BCBuizer Profile Picture
    22,854 Super User 2026 Season 2 on at

    Hi @Joanne76 ,

    You have posted this topic in the Power Apps community, but it seems to be about Power Automate. Probably you have a better chance of getting a solution by posting it in the Power Automate Community: https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • Joanne76 Profile Picture
    8 on at

    Thanks for the advice, I'll try there

     

  • gan Profile Picture
    28 on at

    Did  you manage to fix this? I am having the same issue.

  • Joanne76 Profile Picture
    8 on at

    Unfortunately not. I found that the cause of the problem was the forward slash in de column title Jaar/Week. If I changed it in a test document to JaarWeek it worked fine. However I had no way to change the column title in my actual source, so I eventually abandoned the project. 

  • gan Profile Picture
    28 on at

    Thank for the reply, I came to the same conclusion as you did. Truly ridiculous that Power Automate can't deal with a forward slash.

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

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 405 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 368

#3
WarrenBelz Profile Picture

WarrenBelz 244 Most Valuable Professional

Last 30 days Overall leaderboard