1 Forms Response Triggers an Email with data from 2 Forms

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I am new to Automate and am setting up email notifications of Microsoft Form responses. I have no issues sending an email with the data from a single form but I can't figure out how to send the data from 2 forms.

Form 1's data is an excel sheet in my OneDrive. Same with Form 2. Form 2 has a field for "Form ID" where the user manually enters the response ID they are sent by email when Form 1 is submitted. (These are two part forms that two different users complete).

I have tried Get Response from both forms using the FORM ID field as the link (as a conditional statement). The yes response is what I am actually looking for. The no response is a fall back if it doesn't work (which it's not). So I don't really need a conditional statement I just have no ID how to link both forms.

Does anyone have suggestions?

Annotation 2020-01-24 094606.png Annotation 2020-01-24 094606 2.png

I have the same question (0)

All responses (1)

Answers (0)

yashag2255 24,695 Super User 2024 Season 1 on at

Like (0)

Report

Re: 1 Forms Response Triggers an Email with data from 2 Forms

Hi @Anonymous

I would recommend creating two separate flows.

1st: Triggers when the first form is submitted and saves all the details to SharePoint and then sends the sharepoint item ID to the user to link the next form. The second user will use this sharepoint ID (this is a simple numeric) as a response to one of the questions and provide their responses.

2nd: Triggers when the second form is submitted and gets the item from SP list based on the id submitted and then perform comparison/ conditions and send the consolidated email.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No