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:
I have trouble filling the row because the Excel file is created during the flow itself.
For example this works when I point to the ExcelTemplate:
But when I try to approach it dynamically like this:
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:
This seemed to be somewhat in the right direction since I now could add the item properties.
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