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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Unable to add a row in...
Power Automate
Answered

Unable to add a row into table

(0) ShareShare
ReportReport
Posted on by 38

Hi,
I will get an email everyday in outlook with an attachment excel file. I need to save that file in share folder and copy the data from excel file and paste the value in template which is already present in the share folder. The template is having pivot table in it. I am getting two errors. First error is in tables I am not getting the column values but when I changed the template without pivot table I can see as Table 1 with all column values. The flow run successfully without pasting any values in my template file. I am new to power automate. Any help will be appreciated.

Categories:
I have the same question (0)
  • Verified answer
    Riyaz_riz11 Profile Picture
    4,000 Super User 2026 Season 1 on at

    Hi @manish_kumar94 ,

     

    Here you need to use apply to each for adding into rows.

    Ahammad_Riyaz_0-1655889028295.png

    In my case it was getting fine, because i was using directly, here you need to write expression what i was written in note in above screenshot please refer that. Mine it was id your case you can define your column name .

    items('Apply_to_each')?['Id']
     

    Regards

    Ahammad Riyaz

    --------------------------------------------------------------------------------
    If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

     

     

  • manish_kumar94 Profile Picture
    38 on at

    Thank you so much for helping me.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 248 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 207 Super User 2026 Season 1

#3
Power Platform 1919 Profile Picture

Power Platform 1919 101 Super User 2026 Season 1

Last 30 days Overall leaderboard