SharePoint Update Item with Custom Collum and Forms Response

[MichaelD88]

Hi

I currently try to build a Flow that updates a Share Point List entry when a Forms response is submitted. Where one Answer from the Form is the match for the Share Point List

So the flow should do this:

Form Question 1 asks for the employee ID. After the Form is filled out, the Flow looks for the row in the share point list, then updates one file in this list with a specific value.

I started with a flow that uses When a new response is submitted as a trigger, then get response details, then update item (add a value to a list item)

My Problem is that I can't match the row with the employee ID (Question 1). There is a mandatory field "ID" in update item, which I think is used to look for the rows that should get updated, and Title is, I think the value within the row. I can't get it to match the employee ID from the question to the row within the share point list.

Does anyone any idea how I can get this done?

I'm more used to Excel then share point lists, but want to move away from excel. In excel though there is update row action where you set the column you look for and the value of the entry you look for, then you can change other entries in this row.

Thank you.

Further Info regarding the use case:

The SharePoint List is a List with employees, and contains the employee ID, employee Name, employee e-mail address, the supervisor name, supervisor e-mail address and a deadline.

The deadline is for a regular feedback call between employee and supervisor, part of the feedback call the mentioned form.

What I currently try to build is a flow that reminds both employee and supervisor about the feedback call and to fill out the form. So both sides are ready when the call takes place.

This seams to work, so the flow sends reminders via mail to both or only to the supervisor if the employee does not have a mail address (company provided, we do not mail to private addresses).

Now I wondered what would happen if the form is filled out.

The flow would still send the reminder, this is where the new flow should come in.

Currently the Reminder Flow checks for the deadline, then sends two reminder one if the deadline is reached, or one before that.

To do so there is a entry in the Filter Query part of "get items" that looks in the deadline column and checks if the date is met or the date - 30 days is met, if true the reminder gets send. (Flow runs daily).

Now I thought to add a condition to this, so the filter looks for the deadline part and for a value in another column. Meaning the List would have a new column that has a default value (No), and that would be the condition for the reminder, so the new flow (when a Forms response is submitted) should change the entry from "No" to "Yes" (or whatever), so that the reminder is not send.