Answered

Updating an existing item in a sharepoint list when there is a new microsoft forms response

(0) Share

Report

Posted on by Chloe3

Hi all,

Hoping you can help as I've been trawling the forum for solutions but nothing I have found so far has helped. I'm trying to update an existing SharePoint list item with new information received as a microsoft forms response. The current point I'm using to try and locate the item in the list is the employee's name, so it is both a column in the list (Name) and a field in the form response (New starter's name).
I've included pics of what I have tried so far, if you can see something wrong with them or have a different way of achieving what I need please let me know. Thankyou!

One thing I have noted is that in many of the processes I am trying to follow, the initial output selected is a list action, whereas the only one I have available is the response ID

The first was following this process

Solved: I want Flow to use a FORM that, when submitted, wi... - Power Platform Community (microsoft.com)

Where the functions in the update item action are

body('Filter_array')[0]?['ID']

and

body('Filter_array')[0]?['Title']

The other I followed was as follows:

Categories:

Business Process Flows

All responses (4)

Answers (1)

Chloe3 9 on at

Like (0)

Report

Re: Updating an existing item in a sharepoint list when there is a new microsoft forms response

Sorry ignore this, I was looking at the wrong flow. With this one the flow succeeded, however the data did not populate the sharepoint list
Chloe3 9 on at

Like (0)

Report

Re: Updating an existing item in a sharepoint list when there is a new microsoft forms response

Just to follow that one, I have tried rebuilding the flow as you described, however the flow failed. I've attached the run info:
The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@triggerOutputs()?['body/resourceData/responseId']' is of type 'Integer'. The result must be a valid array.
Chloe3 9 on at

Like (0)

Report

Re: Updating an existing item in a sharepoint list when there is a new microsoft forms response

Hi @v-liwei-msft,

Forgive me if I'm incorrect, but that looks like the steps I've taken in the second flow I provided, which is not currently adding the output to my sharepoint list. Based off the pictures I included in my original post, am I doing something wrong at one of the steps?
And yes you're correct, I am trying to update an existing sharepoint list item with the answer from a microsoft form.
Verified answer

v-liwei-msft on at

Like (0)

Report

Re: Updating an existing item in a sharepoint list when there is a new microsoft forms response

Hi @Chloe3

Could you please tell me:
Are you trying to update SharePoint based on the answer returned by the Form?
I think the overall idea of your flow is correct, but it could be a bit more streamlined.
I made a test for your reference:
1.
2.
3.
4.

Best Regards,
Levi