Unanswered

Copy Excel files content to SharePoint list

(0) Share

Report

Posted on by Community Power Pla...

Hi guys,

On one side, I have a SharePoint library with multiple Excel files with the same structure (each file has only one table always named "Table1").

On the other side, I have a SharePoint list where the items names are identical to the Excel file names.

I would like to run a flow whenever one of these Excel files is modified, in order to copy the content of Table1 into the corresponding list item.

It seems pretty simple but I've tried many flows and can't seem to find something that works! Would you have any idea on what the best approach should be?

Thank you,

Nicolas

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

JPMHuls 103 on at

Like (0)

Report

Hi Nicolas,
Does your list have multiple items per Excel file (so an item per table1 row)? Or only 1 item with the content of table1 in a column (e.g. as an HTML table)?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hello,
It has multiple items to copy but from the same row in Table1 (This table actually has only one row). I found a way to instruct the flow to read from the file in question after using the "Identifier" info from "Get file properties" in the "List rows present in a table" action, but at this point the main issue I'm facing is that I don't know how to tell the flow that the table to read from is this Table1 as the field doesn't accept dynamic names.
Thank you!
Nicolas

Was this reply helpful? Yes No
Verified answer

JPMHuls 103 on at

Like (0)

Report

Hi Nicolas,

In a flow i use for moving MS Form data to an Excel for mileage and fuel consumption I have the following action:
Table is a dropdown showing you the available tables. For dynamic table selection you find at the bottom the option 'Enter custom value' which I used to specify the month from the submitted registration date.

So to create SP list items for each Excel table row, you need to use this action and then loop through each table row to create a list item. If you want to update existing SP list items you need to include some unique reference in both the Excel as in the SP list.

NB: here's the action to add a new line to Excel with dynamic table selection:

Was this reply helpful? Yes No