Skip to main content

Notifications

Community site session details

Community site session details

Session Id : rBm/O2PF+nZupXbv1qWoOS
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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,702 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,030 Most Valuable Professional

Leaderboard
Loading started