You’re offline. This is a read only version of the page.
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.
Share
Report
All responses (
Answers (
2,429
