Hello Guys, Hope You can help with this one.
I have a flow that needs to check if an item already exist on a Master list, if the item exist then update it, if it doesn't exist then create the item.
The issue I have is when I use a "Get Items" to query the "Master List" it goes through every single item in the "Master List" checking if the values match, if they don't match then it creates the item, BUT then it moves to the next item and it tries to create it again, and again for each item it checks. it seems that is not checking the entire list and choosing to create the item or update it after it checks the list. It does this 100 times and then it fails because some of the values are unique.