Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Process Mining
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:
  • manish_kumar94 Profile Picture
    38 on at
    Re: Unable to add a row into table

    Thank you so much for helping me.

  • Verified answer
    Riyaz_riz11 Profile Picture
    2,666 Super User 2025 Season 1 on at
    Re: Unable to add a row into table

    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.

     

     

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

🌸 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 - Process Mining

Overall leaderboard