Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Insert a row to an Excel file accessed via on-prem gateway

(0) ShareShare
ReportReport
Posted on by 59

I may be missing something really obvious here but how can I insert a row into a table in an Excel file when that file is on an on-prem server and not on OneDrive/SharePoint? The Insert a row action only give the option for OneDrive for Business.

 

If this is not possible is there at least the option to use the Insert a row action for a file located in a SharePoint document library? If so how?

  • Verified answer
    v-yuazh-msft Profile Picture
    on at
    Re: Insert a row to an Excel file accessed via on-prem gateway

    Hi @mark-carlisle,

     

    If you want to insert a row into a table in an Excel file when that file is on an on-prem server,

    I afraid that there is no way to achieve your needs in Microsoft Flow currently.

    Inserting a row into a table in an Excel file when that file is on an on-prem server is not supported in microsoft flow currently.

    If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

    https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

     

    If you want to use the Insert a row action for a file located in a SharePoint document library, please refer to steps below to create the flow:

     

    1.Add action Manually trigger a flow.

    2.Add action "Add a row into a table" of excel Online (Business) connector.choose the sharepoint site, library and file to insert the row.

     

    Capture.PNG

     

     

    Best regards,

    Alice

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