Hello,
In this workflow I am adding plain xlsx file to a SharePoint document library.
Once the file is added, I am using the "Create table" action to add a table to the document.
Then I use a 60 second delay action to allow time for the table to be added.
Next I use the "List rows present in a table action" with the Filter Query of Title ne '' to stop blank rows from being added to my SharePoint list (futher down).
Next I use the Apply to each action to grab the value from the previous step (List rows present in a table).
I then use the Get items action to bring back the values of items already existing in a SharePoint list.
Next I add another Apply to each action with a Condition where it checks whether the "EmployeeID" column in the SharePoint list matches the data from the EmployeeID column in the excel file.
If the data matches (If yes) then do nothing and if it doesn't match (If no) then add new content to the SharePoint list.
I tested this workflow first before addition in the conditional actions to check that data can be populated to the SharePoint list from the Excel file and this worked perfectly.
However my next action is to do the conditional checking, however this is not working correctly and is just creating many duplicates in the SharePoint list instead.
Any pointers to what I may be doing wrong?
