I need to send a list of items in sending a mail but here I need to connect with two tables in powerautomate

[Sweety]

Hi,

I have created a flow when an item is created in sql it should trigger a mail so showed list of items like 

created By, Title , Target Date, Assigned To , status , priority, Description 

I got the list of items in mail but here I need status =new instead of status =1 

In my table I stored as id as integer and I connected to only one table so it’s showing the result set of items 

if I need to show as text I need to connect another table status table 

can some one tell how to connect multiple tables or how to write a query in mail to get the status 

please refer below screenshot 

[v-albai-msft · Accepted solution]

Hi @Sweety ,

I would suggest you create a variable to keep the Status value from another table. Flow like this:

Notes:

1. Use "Get rows(V2)" action to list all records from the second table. 

2. Then check each records got from above to find the correct record which meet the condition.(complete the condition based on your actual need) 

3. If condition is met, set the Variable using value from the eligible record.

In the last of the flow, send an email and use the Variable of the Status column.

You can refer to this thread:

https://powerusers.microsoft.com/t5/Building-Flows/Join-Two-Datasets-in-Flow/td-p/354458 

Best regards,

Allen

[Sweety]

thank you ,it’s working