Unanswered

Flow with rows from two tables (SQL)

(0) Share

Report

Posted on by AntFrench

We have created a flow to query a table and email rows if expiry date is passed, this works. However, one of the key fields in the table is an ID which links to a full name in another table. We can get the rows from this table. Is there a way to combine or join the two tables or can we lookup a value in the second table from the ID in the first. What is the correct approach to solve the problem?

Many thanks.

Categories:

General topics

All responses (3)

Answers (0)

Sort by

v-monli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Ant,

According to my test, this cannot be achieved so far in flow. As you cannot manage 2 different tables in one action. And flow cannot extract another table according to the links in SQL. I suggest that you can post an idea in the Flow Idea forum so it might be considered in future release:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Regards,

Mona Li
AntFrench 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the update.

In the end I added two extra field to my access web app table which are updated for the lookup values I need, rather than just id's.
Ramin Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, any update on adding this capability? I am dealing with the same exact issue (need to be able to do a JOIN so I can go from ID in one table to name in another table).