Skip to main content
Community site session details

Community site session details

Session Id : 8DGv3OW4EILGIr5plB/mFq
Power Automate - Building Flows
Answered

Update row in Excel after creating a new Excel file

Like (0) ShareShare
ReportReport
Posted on 20 Feb 2024 14:05:13 by 427

Hello,

I need some advice on the current implementation that I'm trying to achieve. During my Power Automate flow I create a new file in a Document Library basedon /copied from a standard Excel template. In this new file I want to update the rows by populating the Data worksheet that I setup using this source: Fill-In An Excel Template With Power Automate (matthewdevaney.com) 

 

My Excel has the following CancellationTable:

DJanssen_2-1708437101486.png

I have trouble filling the row because the Excel file is created during the flow itself. 

DJanssen_0-1708438028770.pngDJanssen_1-1708438098449.png

 

 

For example this works when I point to the ExcelTemplate:

DJanssen_3-1708437205792.png

But when I try to approach it dynamically like this:

DJanssen_4-1708437607778.png

I don't even get to fill in the value. 

 

I tried putting in the Table with code values by doing a Code peek and using the Table value found when the file is known:

DJanssen_0-1708437855564.png

This seemed to be somewhat in the right direction since I now could add the item properties.

DJanssen_5-1708437693629.png

But this results in the following error: 

 

 

 "error": {
 "code": "",
 "message": "The request entity's media type 'text/plain' is not supported for this resource."
 },

 

 

Can somebody point me in the right direction or help me out? 

 

Best wishes



 

 

  • Verified answer
    DJanssen Profile Picture
    427 on 20 Feb 2024 at 14:32:09
    Re: Update row in Excel after creating a new Excel file

    Update: seems that I can just create a copy after filling in the template and keep updating the template and creating new copies from it. This has been solved!

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

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!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Loading complete