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

[Anonymous]

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

[FLMike]

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

[RobElliott]

@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)

[Anonymous]

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

[_minnies_]

@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?

[Anonymous]

@_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.

[_minnies_]

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.

[RobElliott]

@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)

[Anonymous]

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

[Anonymous]

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

[RobElliott]

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)