Forum Discussion

Laurens2207's avatar
Laurens2207
Copper Contributor
Apr 03, 2020

Using forms to populate an existing Excel file

Hi everyone,   I have a question related to forms. I work in Teams on a excel file (name: File A) that I need my team to populate with data. Now File A is quite big (and for outsiders a bit messy :...
excel
microsoft forms
Survey
RobElliott's avatar
RobElliott
Silver Contributor
Apr 03, 2020

Laurens2207 the form can't populate File A directly but you can grab each form response with a flow in Power Automate and add the answers to each question to the appropriate column in a table in File A on OneDrive.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

tjzarra's avatar
tjzarra
Copper Contributor
Jun 08, 2022

RobElliott 

I'm having issues getting a form to add the row. I have one working from 3 years ago. I used the same process and it just doesn't work. What has changed?

  • RobElliott's avatar
    RobElliott
    Silver Contributor
    Jun 08, 2022
    Nothings changed with that as far as I know. If you post a screenshot of the flow we could take a look.
    • tjzarra's avatar
      tjzarra
      Copper Contributor
      Jun 08, 2022

      RobElliott 

      I'm not seeing the choices to link

       

       

      • RobElliott's avatar
        RobElliott
        Silver Contributor
        Jun 08, 2022

        tjzarra you don't want that apply to each: it is an error in the template that Microsoft have never fixed and it causes problems. Delete it. Immediately after your when a new response is submitted trigger you need the get response details action then everything should be fine after that.

         

        Rob
        Los Gallardos
        Microsoft Power Automate Community Super User

Resources