Update existing excel table from an uploaded excel file

(0) Share

Report

Posted on by JCBq

Hello,

I have a problem with a recent flow and I don't know how manage it, I think I don't have the best approach.

I have an excel file with the table 'data'.
The flow is supposed to generate a report with my sharepoint data and external data.

For that, I created a form which ask to upload an excel file (and asks other parameters)

The flow starts when the form is filled.

I successed to have the variable path to find my new uploaded excel.

Now I wanted to replace (or add) the rows from my new excel to my existing table (and after, the flow work on this data)

The problem is I haven't found the proper way to add rows from an uploaded excel to my existing excel

The columns are not supposed to change

I tried to do 'create new table', but when comes to 'add row to a table' I don't know how to do this (it is also problematic when I tried to just "update" my sharepoint file with the excel content, 1 time/2 it crash because of shared use and Powerautomate can't guess what are the columns of the file I'll upload (even if I don't want to change it)

Thanks in advance!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Kannan_n 511 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi JCBq

Can you pls share your flow screen shots after only I can understand what you want to do.
I think you want to update excal based on your share point list. But I don't it's right. But give me more information about your problems.

Thanks
Kannan. N

Was this reply helpful? Yes No
JCBq 5 on at

Like (1)

Report
Copy link

Link copied!

Hi
the form on the Sharepoint site:
Here is the current flow

1) When the form is send, delete all lines from the permanent Excel
2) Add lines from Sharepoint data to my report, here it works fine

3)
Find the uploaded excel
I managed to do it like that:

concat('/Documents partages/Applications/Microsoft Forms/MyForm/Question/',replace(first(split(outputs('Obtenir_les_détails_de_la_réponse')?['body/r6c1b83e100b74af2803393f340ce0220'],'.xlsx')),'[{"name":"',''),'.xlsx')

Then update the permanent excel with the uploaded excel
Columns are the same, same table name

And after, use the permanent excel to add lines to my report

Problems are: with the method "update file", there is an issue with shared use
I want to make the permanent excel (which I use with the rest of the flow to make my report) be the same as the uploaded excel (or add/update the lines from the uploaded excel to the permanent one)

For example:
Permanent excel: 1, 2, 3, 4, ...
Uploaded excel: 5, 6, 7, 8,...
I want the permanent excel updated to be: 5, 6, 7, 8 (or 1, 2, 3, 4, 5, 6, 7, 😎

Best way would be to add lines from the uploaded excel to the permanent (or update)
but I don't find the way to have Powerautomate "for all lines, make a new line for column 1, add to column 1 ..." because it don't know what is the excel I gonna upload (even if it's supposed to be the always same columns)

thanks!

Was this reply helpful? Yes No