Answered

Update Sharepoint List When File Uploaded or Modified

(0) Share

Report

Posted on by Alex41

Hello,

I am trying to build a flow that updates a sharepoint list as files are added to a folder. The files are excel workbooks that have a common named table and I would like the flow to search for this table when it is uploaded and import that data to a sharepoint list. Much like how the power query function works in excel for example. Thank you,

Alex

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

You can use When file is created in Folder trigger, to run the flow when file are added to folder

Then you can refer to this post on how to get the tables from excel https://powerusers.microsoft.com/t5/Building-Flows/Send-emails-to-people-in-weekly-reports/m-p/785006 follow the steps from step 5 to get the table from excel.

Once you got table from excel, you can list rows from that table and loop through the rows and within the loop you can add data to SharePoint using Create Item action

Was this reply helpful? Yes No
Verified answer

v-yiwenxie-msft Microsoft Employee on at

Like (0)

Report

Hi @Alex41

First, Find the specific table in the excel workbook：

You get all the tables in the specific excel workbook.
And you can filter the exact table you want using the ‘filter array’ action.
Get the data from the exact table by using the ‘list rows present in a table’ action.

Then, import updated excel data into SharePoint list by deleting all the list items and importing all the excel data in the list.
But, if your SharePoint list is not synchronized with the excel workbook (which means the list contains data not from the excel workbook), then the step must be changed.

Could you tell me whether the SharePoint list contains data not from the excel workbook?

The whole flow is as below:

Best Regards,
Community Support Team _ Kira Xie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Alex41 2 on at

Like (0)

Report

Hello,

I am starting from a blank list right now with column names the same as the table headers and won't have any other data than the excel data. I'm having issues when I get to the "Apply to Each 3" stage where when I am selecting the "column1" and "column2" data I do not get the dynamic expression options of the table data.

Best,
Alex

Was this reply helpful? Yes No
v-yiwenxie-msft Microsoft Employee on at

Like (0)

Report
Hi @Alex41

In the ‘apply to each 3’ action,
The expression for column1 and column2 is:
Items(‘Apply_to_each_3’)?[‘column1’]
Items(‘Apply_to_each_3’)?[‘column2’]

Best Regards,
Community Support Team _ Kira Xie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No