Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Excel Connector: Add a row using File ID Failed

(0) ShareShare
ReportReport
Posted on by 63

I got stuck while using Excel Connector, "Add a row into a table".

I need to add a flow using the connector with dynamic excel files.

I referenced to the information below and successfully get the file ID of the excel file.

How to Read and Write from Dynamic Excel Files with Microsoft Flow
https://johnliu.net/blog/2019/5/workarounds-needed-to-use-the-excel-connector-in-microsoft-flow
https://www.youtube.com/watch?v=64lSykOYmzI

However when I use it in my flow, it get error: 

ericwychan_0-1626681803034.png

 

I set up a parallel step and compare between using dynamic file or choose file directly in the step.

I cannot found any difference in the "show input raw ".

 

ericwychan_1-1626682256104.png

 

"Show input raw" - Success: direct choose file

ericwychan_2-1626682310329.png

 

"Show input raw" - Failed: use expression to fill up dynamic file ID

ericwychan_3-1626682380843.png

 

Please kindly advice what I did wrong on the settings.

Thanks.

  • ericwychan Profile Picture
    63 on at
    Re: Excel Connector: Add a row using File ID Failed

    Peek Code of both steps are provided below.

    I can only found the system has added metadata information at the end of the code (circled in red) after i choose the file. But i don't think it is related to my issue now.

     

    "Peek Code" - Success: direct choose file

    ericwychan_2-1626683401509.png

     

     

    "Peek code" - Failed: use expression to fill up dynamic file ID

    ericwychan_1-1626683303682.png

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1