Unanswered

Update a column in Sharepoint List when new answer submitted in Microsoft Forms

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Dear Community,

I am having trouble using Power Automate to update a column in my Sharepoint List when a new answer is submitted through Microsoft Forms. I have a Forms with three questions and instead of having a column for each question in my Sharepoint List, I would just like to have one column with the answers in the rows below for each question.

Would love some help.

Thanks

Categories:

Using connectors

I have the same question (0)

All responses (10)

Answers (0)

Michael E. Gernaey 53,960 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

Are the number of answers going to always be (at most 3)???

If so then you could simply read the values from the Get Response Details, and add 3 Create Item (not update item) actions.

Essentially you would do this

1. Add a condition action
-Check if the answer is NULL or Blank
--if it NOT then use Create Item action to write that answer to SharePoint

Do this 3 times in a row in the same flow

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
RobElliott 10,420 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Anonymous if you are updating an item in a SharePoint list from a submitted Microsoft Form then you need a way to link the form to the item. So you'd need to have a question in your form for the ID of the item you need to update.

Rob
Los Gallardos
Principal Consultant, SharePoint, Forms and Power Platform, WSP UK (and classic 1967 Morris Traveller driver)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I will have six possible answers. Would it still work in the same way?

Was this reply helpful? Yes No
_minnies_ 91 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous Do you want to have those 3 rows for each question and update just the answer, when a new response was submitted? Do you want to change the previous answer or do you want to collect all the answers?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

@_minnies_ I will roughly have 100 questions in the end. Every one of those questions will have 6 possible answers. I want to have my answers for each question in a different row, not column. As a new Forms sheet will be submitted, I want the answers to be updated in the Sharepoint Lists and not added on.

Was this reply helpful? Yes No
_minnies_ 91 on at

Like (0)

Report
Copy link

Link copied!

Okay. So the id of a particular question won't change. For example if your question 1 has the id 1 you need to update the item with the id 1, if a new answer for question 1 has been submitted. Have you thought about using a Power App instead of a Microsoft Forms? I guess this would be a more convient way to implement this solution.

Was this reply helpful? Yes No
RobElliott 10,420 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous be careful with the number of questions if you are using Microsoft Forms; there is a hard limit of 100 questions but that reduces if you use likert questions as each statement counts as 1 question.

Rob
Los Gallardos
Microsoft Power Automate Community Super User
Principal Consultant, SharePoint, Forms and Power Platform, WSP UK (and classic 1967 Morris Traveller driver)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Yes, that is a good idea. I did indeed hesitate using the Power App. Might give it a try.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I have managed to insert over a 100 questions in my Microsoft Forms. Doesn't seem to be a problem for me.

Was this reply helpful? Yes No
RobElliott 10,420 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

It looks as though it has recently been increased to a hard limit of 200.

Rob
Los Gallardos
Microsoft Power Automate Community Super User
Principal Consultant, SharePoint, Forms and Power Platform, WSP UK (and classic 1967 Morris Traveller driver)

Was this reply helpful? Yes No