Forum Discussion
Real time Microsoft Forms results in Excel Worksheet
Hi, I want to use Microsoft forms for an invoice in excel. I have made the invoice, which automatically collects data from the Excel table opened with Microsoft Forms, but when a new response has...
Can we use the different eForm to collect data and populate the info into the same workbook but different worksheet?
Nope, that doesn't work.
- SergeiBaklan
How about same eFORM but using power automate ? I manage to use power automate to split the data with "condition" function used. But the data will goes to different workbook. Any idea how to put the data under same workbook, different worksheet?I didn't try, but most probably yes. Power Automate allows you to add row to any table in any file. Dynamic content for row could be taken from data triggered by Microsoft Forms.
