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 / 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 2025 Season 2 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 2025 Season 2 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 2025 Season 2 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

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 375 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 269 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 127 Most Valuable Professional

Last 30 days Overall leaderboard