Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Send email based on form response

Like (0) ShareShare
ReportReport
Posted on 14 Jan 2025 16:56:38 by 2
Hi
 
I am trying to create a flow that will send an email based on the response to a form. The form will contain a supplier name and that supplier has an owner.
 
Neither the supplier owner, nor the supplier owner email will be contained in the form, this is in a separate table mapped to the supplier.
 
My question is, how can I automate the email to be sent to the supplier owner - so effectively looking at the form and then based on the response, emailing the corresponding supplier owner that a new form has been submitted.
 
Thanks in advance.
  • DR-14011651-0 Profile Picture
    DR-14011651-0 2 on 15 Jan 2025 at 09:06:55
    Send email based on form response
    Hi David
     
    That's great, thanks for the quick response.
     
    Do you have an example of how this works and the syntax etc for the filter query and error handling? I am fairly new to power automate so any examples would be greatly appreciated.
     
    Thanks again for your help.
     
     
  • David_MA Profile Picture
    David_MA 8,219 on 14 Jan 2025 at 17:28:40
    Send email based on form response
    Use a Get items action to return the items from the separate table where you store the e-mail address using a filter query. You will need to do some error handling to make sure only one row is returned matching the supplier, as well as error handling if it does not find a match.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

End of Year Newsletter…

End of Year Community Newsletter…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #11 New Opportunities…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,638

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,433

Leaderboard
Loading started