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.