Unanswered

Creating a SharePoint list with new values from an Excel File

(0) Share

Report

Posted on by AS2021

We currently have a SharePoint list which updates every weekend using a flow which pulls the values from an Excel File. This file is updated externally, with the flow deleting the existing contents of the list and recreating it from the Excel file.

I'm trying to create another list which contains the new values which were added to the Excel file in the last update. I've tried cross-referencing the Excel values with the original list before it updates and pushing those which aren't there onto the new list but I've not had any luck creating this flow. Is there a better way to go about this?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

jdoss 458 on at

Like (0)

Report

I've done something similar before and it is possible. Can you share a screenshot of your flow currently?
Also there are other options to get the new data as dealing with an excel file can be tricky. If someone has the file open your flow won't run. You could try creating a Form and connecting the flow to that and update both the excel document and your list based on new form entries.

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @AS2021

If you looking to compare two excel sheet then you can iterate and compare both rows. But that may be time consuming. There is an intersection expression which you could use to find the common values. Then iterate the common value array to delete the second excel rows hence you will have the difference of row values between Excel 1 and 2.

Here is a sample video which I made a while ago about how to use intersect.

https://www.youtube.com/watch?v=3skdTakRRdY

Was this reply helpful? Yes No