Hi - I am working on a flow for my company where changes in a sharepoint folder will get tracked in a sharepoint list. E.g. someone updates the status of a file, the item then gets updated on the sharepoint list as well. To identify the correct item on the sharepoint list, there is a unique ID being created for each item of Client Name_Year End_Type of Work_Type of Document. I am using the "get items" step to filter based on the unique ID, then later using a condition to check if the length of the get items step is = 0. If it is equal to 0, it gets added to the list, if it is not, it gets updated.
I am still in the test phase and have been deleting files and re-adding them to test things out. Now when I run the flow, the get items is showing that a value exists even though the sharepoint list is empty (I deleted the recycle bin as well). So when it gets to the condition for length(get items) <> 0, it tries to update the item, but can't find it. I cannot figure out why it is continuing to think there is an item there that does not exist. There is even a link to it that I can only access from the output of the flow, I can't find the sharepoint list item anywhere else.
Any help would be really appreciated because if I can't figure out how to update per the unique ID, my whole flow will be useless. Thank you!