Answered

Exporting Excel Data to Sharepoint List

(0) Share

Report

Posted on by niketowns

Hello!

Here is my current issue. I receive an excel file every week with an excel attachment which I would like to ingest into a sharepoint list. I have tried the existing Excel connectors and actions (namely "List rows present in a table") but it seems like it doesn't work with a new file.

Anyone have successfully got this to work or have any insight?

Thanks!

Categories:

Using connectors

All responses (3)

Answers (1)

Sort by

Verified answer

v-litu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @niketowns,

Unfortunately, it is unavailable to export Excel Data if the Excel file was dynamical.

It is a submitted idea in the IDEA forum, you could head to vote it to make it come true in the future:

https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Allow-Dynamic-Content-in-Excel-File-fields/idi-p/188582

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
sudharsan1985 1,325 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @niketowns
You can read the rows of the excel file and update to SharePoint, but you have to maintain the excel template such that there is no change in the template. In such a way for all the excel files which is following the template will be successful.

Hope it helps, please like it or mark it as a solution if it resolves ur clarification or issue
-Sudharsan K...
niketowns 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Sudharsan,

Thanks for the reply! Could you please elaborate on how to read the rows of the excel file? Which connectors should I be using?
All of my excel files follow the same format.

Thanks!