Collect Different Forms Responses and Put in one Microsoft List

%3CLINGO-SUB%20id%3D%22lingo-sub-2273374%22%20slang%3D%22en-US%22%3ECollect%20Different%20Forms%20Responses%20and%20Put%20in%20one%20Microsoft%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2273374%22%20slang%3D%22en-US%22%3E%3CP%20class%3D%22x-hidden-focus%22%3EIs%20there%20a%20way%20to%20collect%20responses%20from%20two%20or%20more%20different%20Forms%20and%20place%20responses%20in%20one%20Microsoft%20List%3F%20Also%2C%20is%20there%20a%20way%20to%20link%20to%20another%20form%20using%20Automate%20in%20an%20email%20generated%20after%20one%20form%20response%20is%20completed%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%2C%20I%20have%20a%20Form%20that%20a%20trainee%20is%20supposed%20to%20fill%20out%20following%20a%20training%20event.%20Once%20the%20trainee%20fills%20out%20the%20form%2C%20an%20email%20is%20generated%20that%20goes%20to%20the%20trainer's%20email%20they%20selected%20from%20the%20Training%20Form.%20The%20trainer%20selected%20gets%20the%20email%20and%20a%20link%20to%20the%20trainee's%20responses%20to%20review%20the%20responses%20from%20the%20trainee.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22x-hidden-focus%22%3EI%20have%20another%20Form%20called%20the%20Trainer%20Response%20Form%2C%20which%20is%20what%20the%20trainer%20would%20ideally%20fill%20out%20after%20review%20of%20their%20trainee's%20response.%20I'd%20like%20to%20collect%20the%20responses%20from%20the%20Trainer%20Response%20Form%20and%20have%20them%20populate%20in%20the%20same%20Microsoft%20List%20as%20the%20Trainee's%20form%2C%20corresponding%20to%20the%20trainee's%20responses.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAdditionally%2C%20what%20I'd%20like%20to%20do%20is%20somehow%20have%20a%20link%20to%20the%20Trainer%20Response%20Form%20within%20the%20email%20that%20is%20generated%20to%20the%20Trainer%20after%20the%20trainee%20completes%20the%20Training%20Form.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22x-hidden-focus%22%3EIs%20this%20possible%2C%20or%20did%20I%20just%20merely%20give%20the%20Microsoft%20a%20new%20idea%20that%20I%20should%20get%20credit%20for%2C%20lol%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2273374%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Is there a way to collect responses from two or more different Forms and place responses in one Microsoft List? Also, is there a way to link to another form using Automate in an email generated after one form response is completed?

 

For example, I have a Form that a trainee is supposed to fill out following a training event. Once the trainee fills out the form, an email is generated that goes to the trainer's email they selected from the Training Form. The trainer selected gets the email and a link to the trainee's responses to review the responses from the trainee.

 

I have another Form called the Trainer Response Form, which is what the trainer would ideally fill out after review of their trainee's response. I'd like to collect the responses from the Trainer Response Form and have them populate in the same Microsoft List as the Trainee's form, corresponding to the trainee's responses.

 

Additionally, what I'd like to do is somehow have a link to the Trainer Response Form within the email that is generated to the Trainer after the trainee completes the Training Form.

 

Is this possible, or did I just merely give the Microsoft a new idea that I should get credit for, lol?

3 Replies

@EmmittS3 it's all completely do-able using a flow in Power Automate. I'm tied up in meetings this morning but will post up a how-to with screenshots as soon as possible.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

@RobElliott - Glad to know it is doable. That gives me hope. Looking forward to the response because I have been trying to figure this out on my own and have not been able to figure it out.

@RobElliott - Have you had a chance to work on the how-to of this, or direct me to someone or a source that can help me figure this out?