So I am building a place to upload training certficates, I am using microsoft forms to let users uplolad their certs and they are saved into a list on sharepoint using a flow. However, I am having issues with getting the flow to determine if a user has already uploaded a cert, if they have then I want to update their item with with the new cert and a new date of renewal is set.
The value I am check to see if someone has already uploaded a cert is the EmployeeID, if that ID exists the list should update, if not then the a new item should be created. To do this I get items and filter by Staff number and then do a conditional check to see if the length is 0, if it is then create new item but the issue I face is that when the staff number is not present the list is empty so the conditional check ends up being greyed out and not running.
Here is my get items, outputs contains the staff number pulled from the user's profile who is uploading a cert.
My conditonal check
As I said this results in the condition just being greyed out if the user has not uploaded a cert before. The flow all works if I remove any conditions but then users will end up with multiple separtate entries. The update user part also works if they exist.
Output:
What would be the best way to check if the staff number is already in the list?
