I have a flow that is designed to send an email message to a user that is dynamically selected based on a related table. Here goes my explanation:
I have the trigger for Add or Modify to an upload data column in Table A (Applications Table), and it is triggering just fine. I am trying to populate the email with the name of the applicant (which is on Table A), as well as the Language of the application which is populating from a lookup to our Language Table (Table B). This is all working fine. The trouble is that on the Language Table (Table B) there is a column for a user (User Table C) that is assigned to that Language. I am needing to pull the email address for the identified user for that Language from Table C (Users) and have that email address be the email that is dynamically determined based on the language identified in the Application. Meaning, Table A references a lookup field on Table B. Table B has a user lookup field to Table C (user) and I need the email from Table C.
Does that make sense? How do I order the flow to get that email address of a user on Table C all the way back to an email that is triggered by an add or modify trigger on Table A? The image below shows the steps I have in place. The /Get Producer Email/ is the one I am stuck on.
(I realize that could get very confusing. Thank you in advance. The internets doesn't seem to have much help on this one.)
