Hi,
I have a flow that runs daily for data that is within SharePoint. It initializes a variable for the Status > Gets all items from the Sharepoint List > Lists all the current rows from the dataverse table > Then initializes a variable for a Invoice Number
Then it a condition to check is the status in the list is the same as the variable and if the item in the sharepoint list is older or equal to 60 days ago (this condition check works)
Then if both those checks are correct, it should check to see if the item is currently in the dataverse table or not, but at the moment it is not working, it is just duplicating all items in the table and keeps adding them.
In the condition, I am checking to see if the invoice number from the dataverse table is the same as the number in the sharepoint list, if it isn't the same it shouldnt add it into the the table but it is.
How do I compare both lists and only add in items that arent in the dataverse list?
I can provide more information if needed.