To prepare the Pieter’s method i’m adding a condition and in the yes branch a compose. This filter will now give us all the items that exist in Excel file 2 but don’t exist in file 1. On the left hand side and on the right hand side to item()?
this filter action has a From set to body('Select_second_Excel')Īnd the filter is set to items('Apply_to_each')? Inside the Apply to each I’m adding a filter action. This will make the flow step trough all the records in my second Excel file. Starting by adding an Apply to each step, setting the source of my data to body('Select_second_Excel') I’m now going to build the following flow. Now we can compare the data in my Excel files and find the new records. We now have two arrays of data representing my rows in my excel files. I will now run my flow just to see if everything is working as expected. Later during this flow I will need to be able to compare the rows at lightning speed, therefore I’m going to massage the data a bit to prepare the comparison steps later on.Īlso important don’t forget to rename your actions! It will help so much to get the names of your actions right when you build your flows. I’m using the List rows present in a table action to read my Excel files.Īnd for the second file it is exactly the same story. If you don’t have tables then you might need to look at reading the data using Microsoft Graph as described in my Read data from excel post. Make sure that you create the Excel files with tables, as shown above. Then I create a copy of the first file and add some more lines to the second file.
Then I ‘m filling the first Excel file with a number of records as shown below. There isn’t too much of a difference between those two options. You could also create them in OneDrive for Business. I’m starting this Tutorial with the creation of my two Excel files in SharePoint.
0 kommentar(er)
