Unable to update Microsoft Lists row

[Jimb148]

Hello, 

I have the following workflow (attached) where I'm looking to firstly add a new row into an existing Microsoft List I have in SharePoint with information from a submitted form. This part I got working fine. 

I then have another form where I need the responses to be added/combined to an existing row (the row that was added from the workflow step above). 

Whenever I try to use the "get row" action, my Microsoft List can't be found. 

If I use the "Update Item" action, I can find my List but I'm not sure what I can do with the provided information that is present. I know when updating an existing row anywhere I need an "Identifier" (which in my case I want to use an email address form response). From what I have in my current workflow, I got nothing populating for me. 

In a nutshell, I need to combine the responses from two separate forms into a single Microsoft List row using an email address field as the identifier between the two forms. 

Appreciate the assistance!

[ManishSolanki]

Hi @Jimb148 

You need to use "Get items" action to get the rows from SharePoint list. Apply filter query to get the row based on the email address. Next, you need to check if get items returns any records by calculating the length of output using expression. If record exists, then you can use "Update item" action to update the list item. The output of get items contains the ID of the list item that needs to be passed to update item action.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.