Forum Discussion
JosephC1995
Mar 17, 2020Copper Contributor
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
Sort By
- RobElliottSilver 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