
Announcements
Hello,
I have two MS forms that I need to "link" together their outputs in an Excel sheet and was wondering how possible this was with Power Automate (or maybe VLOOKUP?).
So let's say MS Form #1 is filled out by a customer. Then MS Form #2 is filled out by staff/employees in response to that. I need to have the form responses from MS Form #2 automatically go right underneath the corresponding customer response from MS Form #1 IN Excel.
Here's an example to further demonstrate:
Form #1 (Customer Alex)
| What's your DOB? | What's your t-shirt size? | What program are you in? | Activity type? |
| 10/25/1980 | Medium | New Web Dev | Mental Fitness |
Form #2 (Employee Allison)
| Is DOB acceptable? | Is t-shirt size in stock? | Program code? | What is the activity rate? |
| Yes | No | AHS8574 | $100/two sessions |
What I need to happen in Excel.
Here is my current flow for MS Form #1.
I hope this makes sense.
Thanks.
Use a SharePoint List instead of Excel - using Create Item to create from your Form #1.
Get rid of Form #2 and get your staff to access the SharePoint list directly and have the extra columns you need.
Either customise with Power Apps or just use SharePoint form.