Create Excel file and add row

(1) Share

Report

Posted on by schwibach

2 Moderator

Hello,

I want to create an Excel File from a template and then add a single row with content from a Forms response to that new file and store it in SharePoint.

I have trouble referencing the newly created Excel file/table.

I could create the new excel file by getting the file content from the template stored in SharePoint and then creating a new file with that content. (I could also create a new table in that file, but that doesn't seem to help me reference the table)

When I add a row to a table, I'm lacking the columns of the table to be filled in.

Is there a way to communicate the schema to PowerAutomate so it will let me fill in the columns for the file.

Thank you guys!

Categories:

Building flows

All responses (3)

Answers (1)

Sort by

Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @schwibach

You want to use Get Table and then Filter on Table Name to get the First Match and save creating an apply to each loop.

You can then call the table name from the filter with:

body('Filter_array')?[0]?['Name']

and the row data is inserted as a JSON object - make sure you get your column names identical as it is case sensitive.

{"Col1":"1","Col2":"2","Col5":"5"}

Please consider accepting my answer as a solution if it helps to solve your problem.

Cheers
Damien

Please take a look and subscribe to my YouTube Channel for more Power Platform ideas and concepts, or take a look at my website. Thanks
schwibach 2 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you so much! Works like a charm. Never would have guessed how to do it myself!!!!
THANK YOU!!!
TechWheel 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Could this work with adding multiple rows?