Hi Guys, I am trying to automate adding items to a SharePoint List.
I have 2 tables. 1 Master (dtMaster) and 1 with new data (dtNewData). The requirement is
that the dtNewData should get compared to dtMaster, and only the uncommon rows should remain. These rows will then be added to a SharePoint List as new items.
The dtMaster has only one column. dtNewData has 11 columns. The primary key for both tables is the 1st column.
dtNewData is read from an excel range (excel table). dtMaster is created by extracting structured data from a webpage.
I found a solution on the forum. When I put sample data into the attached flow, it works. But when I plug this flow into my main sequence, it just gives me a table with no rows.
Find_Common_NonCommon_By1Col_Test.xaml (16.4 KB)