Forum Discussion

JosephC1995's avatar
JosephC1995
Copper Contributor
Mar 17, 2020

Microsoft Forms to Microsoft Excel

Hi, 

 

I tried to extract information from my raw data form that has been automatically generated by the software to another sheet in the same shared-point excel file. For example, I linked cell A1 with my form1 cell A1, however, when new responses come in, my sheet automatically links it to cell A2 of form1. My guess is that the response sort of inserts a new row, thus, my sheet links to cell A2 of form1 which shows nothing. But I want to be able to track in real time the responses that are coming in via the excel spreadsheet. Any advise? Please help. 

1 Reply

  • RobElliott's avatar
    RobElliott
    Silver Contributor

    JosephC1995 you could save the form responses as they come in to another spreadsheet with a flow in Power Automate.

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User

Resources