Answered

Appending dynamically in power automate (onedrive & excel)

(0) Share

Report

Posted on by sabrina45322

I haven't come across this exact scenario yet, hopefully someone can help me.

Here is the scenario: I am getting a fresh excel sheet every day that contains data. The columns are static but the number of rows is variable. These sheets are named dynamically.

I would like to create weekly and monthly summaries of these daily reports, automatically, with dynamic titles.

I have the blank file with an empty table being created successfully, but because it is a "custom field" table my "add a row to a table" seems to be missing some boxes.

I have tried a lot of different ways to fix this. Here is what I currently have.

now in detail:

and the error I have gotten most recently was this one:

ideas?

I have the same question (0)

All responses (3)

Answers (1)

Shujaath_Khan 1,111 Super User 2024 Season 1 on at

Like (0)

Report

Re: Appending dynamically in power automate (onedrive & excel)

Hi @sabrina45322
did even tried creating worksheet using below connector
also, if you've requirement where you've to create new file with specific columns repeatedly,
First you can create a master template file
and secondly every time try to create copy of template file in required folder so you don't have to create file and re-work.

Thanks
Please click Accept as Solution on this reply if it helped to solve your issue, and thumbs-up if you feel this is useful or important in other ways as a boost.

Was this reply helpful? Yes No
sabrina45322 10 on at

Like (0)

Report

Re: Appending dynamically in power automate (onedrive & excel)

Hello,

I did try creating a new worksheet and instead of appending to my table, adding my table to a new worksheet each time. It was not successful. As you can see on my flow, I already have a blank template and generate a blank table with no issue. The issue comes with appending the data from the daily sheets onto the weekly sheets.

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft on at

Like (0)

Report
Re: Appending dynamically in power automate (onedrive & excel)

Hi @sabrina45322 ,

Maybe you could try as below:

{ "Date":@{items('Apply_to_each')?['Date']}, "Campaign":@{items('Apply_to_each')?['Campaign']}, "Inbound":@{items('Apply_to_each')?['Inbound']}, "Outbound":@{items('Apply_to_each')?['Outbound']}, "Total":@{items('Apply_to_each')?['Total']} }

Here is a link that for your reference.

https://tomriha.com/how-to-add-a-row-to-a-new-excel-sheet-with-power-automate/

Best Regards,
Charlie Choi

Was this reply helpful? Yes No