Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

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

(0) ShareShare
ReportReport
Posted on by

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

  • RobElliott Profile Picture
    RobElliott 10,012 on at
    Re: Update a column in Sharepoint List when new answer submitted in Microsoft Forms

    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)

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

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

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

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

  • RobElliott Profile Picture
    RobElliott 10,012 on at
    Re: Update a column in Sharepoint List when new answer submitted in Microsoft Forms

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

  • _minnies_ Profile Picture
    _minnies_ 91 on at
    Re: Update a column in Sharepoint List when new answer submitted in Microsoft Forms

    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.

    _minnies__0-1698303088526.png

     

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

    @_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_ Profile Picture
    _minnies_ 91 on at
    Re: Update a column in Sharepoint List when new answer submitted in Microsoft Forms

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

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

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

  • RobElliott Profile Picture
    RobElliott 10,012 on at
    Re: Update a column in Sharepoint List when new answer submitted in Microsoft Forms

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

  • FLMike Profile Picture
    FLMike 31,580 on at
    Re: Update a column in Sharepoint List when new answer submitted in Microsoft Forms

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard

Featured topics