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 Automate / I am encountering an e...
Power Automate
Unanswered

I am encountering an error in the newly created flow with Power Automate

(0) ShareShare
ReportReport
Posted on by 21

I am encountering an error in the newly created flow. The error occurs during the final step of the process.

Below are the steps I used in the flow. Any assistance would be greatly appreciated.

 

When an email is received, Proceed to create a new Excel file based on the attachment.

This Step works fine.

RatheeshNambiar_7-1715952341559.png

 

Next, generate a new worksheet within the existing file (File 1).

This Step works fine.

RatheeshNambiar_9-1715952420720.png

 

Create a table in the new worksheet using Excel script.

This Step works fine.

RatheeshNambiar_10-1715952468755.png

 

Compose table name.

This Step works fine.

RatheeshNambiar_11-1715952515512.png

 

List row present in a table (Existing file – File 2)

RatheeshNambiar_12-1715952667328.png

 

Populate the data from the Existing file – File 2 to the new worksheet 

I am encountering an error here.

RatheeshNambiar_13-1715952726906.png

 

Below is the error

RatheeshNambiar_5-1715952149569.png

 

@Nived_Nambiar 

 

Thank you

 

Categories:
I have the same question (0)
  • Nived_Nambiar Profile Picture
    18,136 Super User 2026 Season 1 on at

    Hi @RatheeshNambiar 

     

    Are you trying to copy data from csv to new table created in existing file ?

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

     

  • RatheeshNambiar Profile Picture
    21 on at

    @Nived_Nambiar no, trying to copy the data from existing .xlsx file (table format)

  • Nived_Nambiar Profile Picture
    18,136 Super User 2026 Season 1 on at

    Hi @RatheeshNambiar 

     

    Sorry - now got it 🙂

     

    See the mistake you have made is instead of using Run script and getting output as table name to add the rows to File 1.

     

    You should have tried like below

     

    Nived_Nambiar_0-1716139744915.png

     

    Nived_Nambiar_1-1716139764571.png

     

    Nived_Nambiar_2-1716139898773.png

     

     

    Hope this helps !

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

     

  • RatheeshNambiar Profile Picture
    21 on at

    Hi @Nived_Nambiar I have tried the above but getting an error.

     

    RatheeshNambiar_0-1716176101611.png

    RatheeshNambiar_1-1716176141015.png

    RatheeshNambiar_2-1716176252230.png

     

     

      

  • Nived_Nambiar Profile Picture
    18,136 Super User 2026 Season 1 on at

    Hi @RatheeshNambiar 

     

    You should use single quotes around Name dynamic content as shown below:

     

    Nived_Nambiar_0-1716230650375.png

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

     

  • RatheeshNambiar Profile Picture
    21 on at

    Hi @Nived_Nambiar Still I am getting the same error.

    RatheeshNambiar_0-1716263380003.png

    RatheeshNambiar_1-1716263434259.png

    Thank you

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 58

#2
David_MA Profile Picture

David_MA 53 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 36 Most Valuable Professional

Last 30 days Overall leaderboard