When form is submitted - update existing list item

Question

We are trying to find a way in which we can get columns within a list to be updated automatically when a form is submitted. However, the automation needs to be able to match the email address listed in the form, to the email address listed as a column within the list to then know which row to update the details on.

I have tried to create a flow within Power Automate whereby When a new response is submitted, to get response details and then to Update item. Only problem I have is that we don't know the row ID when submitting the form and therefore can't use that as the field to be referenced when locating which record to be updated.

Has anyone else come across this?

Answer 1

Screenshot of what we are attempting to do below.

Answer 2

Dear Emic,

You can create the flow as follows.

I rename the Title column as Email Address.

You may use multiple filter array condition like the following example.

@and(equals(outputs('Get_response_details_2')?['body/***'], item()?['Column1']), equals(outputs('Get_response_details_2')?['body/***'], item()?['Column2']))

Compose: items('Apply_to_each')?['id']

Welcome to share any updates at your convenience.

Thank you for your effort and time.

Sincerely

Cliff | Microsoft Community Moderator

Answer 3

Dear Emic,

May I know whether you need further help on this issue?

Thank you for your effort and time.

Sincerely

Cliff | Microsoft Community Moderator

Answer 4

Hi Cliff,

Thanks for the above. I am not experienced with using the Filter Array when creating a flow. Are you able to provide guidance on what I need to input within the ['body/***']?

Answer 5

Dear Emic,

It is the dynamic parameter generated from Get response details.

If Column1 in the form as I showed above, the parameter looks like outputs('Get_response_details_2')?['body/***'].

So it is based on your flow environment.

You may try that based on your environment.

Welcome to share any updates at your convenience.

Thank you for your effort and time.

Sincerely

Cliff | Microsoft Community Moderator