Adding new item if it does not exist

[gareth2513]

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? 

[Srini007 · Accepted solution]

@gareth2513 

Check below link for your reference

https://tomriha.com/how-to-check-if-sharepoint-item-already-exists-in-power-automate/

Hope this will help you

Thanks,

Srini

[gareth2513]

Thanks @Srini007 That is acutally what I have been trying but using staff number rather than email but like I said when I do this I just get the greyed out condition. 

[gareth2513]

I actually ended up starting this from scratch, not sure what was throwing it off in the first flow but now it is working using the method above.

Full Flow for those interested: