Forum Discussion
power query with power automate to excel sheet
what is the best way to take 1 workbook that has multiple sheets of different land fill areas and link them all to a master sheet whereas new lines are added, and data is input it will automatically also add it to the working master copy. The data that will be input ideally would be coming from a Microsoft form that was created with the same questions as the column headings so the data will go into the correct spot on the sheet and then auto update to the master copy.
Ive tried linking my form but was not successful.
1 Reply
If to create new form from Excel for web it creates the table within such file which will be updated automatically.
If the form is already created, when to create flow (Power Automate) which updates table in some Excel file on each answer received. In that case table shall be created manually and all already exist answer to be added manually as well.
