How to Get Row ID for a related table in Power Automate

(1) Share

Report

Posted on by SpaghettiG

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.)

All responses (2)

Answers (1)

SpaghettiG 8 on at

Like (0)

Report

How to Get Row ID for a related table in Power Automate

That seems to be it. I was getting stuck on the last bit and I think my organization also had a fun little limitation on OpenApi connections so I also switched to the Send and Email (V2) option instead of the Send an email notification (V3) connection and that seemed to fix the last little bit of my issues as well. But your lookup structure of things was what I needed. Thank you.
Verified answer

Leah Ju Microsoft Employee on at

Like (1)

Report

How to Get Row ID for a related table in Power Automate

Hi Partner,

Table C has a 1:N relationship with Table B; Table B has 1:N relationship with Table A?

You want to send an email when a record is added or modified in table A. The email contains: the name of table A, the lookup value of table B on table A, and the email of the associated table C.

If I understand correctly, you can refer to the following flow:

I hope you can mark my answer verified if it is helpful! If you have any questions, please feel free to contact me.
Regards,
Leah