Lookup data from getrow action

(0) Share

Report

Posted on by RmanNzrnk

Hello

I have flow with 2 getrows actions.

1st action retrieve data filtered by "creation day" - assets, added to database today

Data contains columns:

Asset Name

Purchase Date

Supplier ID

2nd action retrieve data from 2nd database, and contains columns:

Supplier ID

Supplier Name

I need to build HTML table with data from 1st getrows action, but replace Supplier ID with Supplier Name from 2nd action.

Any help or advice will be greatly appreciated.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

ChristianAbata 8,953 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

hi @RmanNzrnk please try this solution that I made with excel

Was this reply helpful? Yes No
Verified answer

krootz 458 on at

Like
a
(0)

Report
Copy link

Link copied!

@RmanNzrnk if you're using get rows from a database either SQL server or Oracle, I suggest you create a view in the database schema with a join between the two tables on Supplier ID with all the columns that you need. You can then use that view for your get row action instead. It's cleaner and will help with performance especially if you have a lot of records. If you can't create a view, then try @ChristianAbata 's recommended solution below.

Was this reply helpful? Yes No
tom_riha 10,187 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @RmanNzrnk ,
I'd add the action 'Get a row' inside the 'Apply to each' where you're processing the rows from the 'List rows' action.
For each row you're processing from the first file, 'Get a row' from the second file where 'Supplier ID' column is equal to 'Supplier ID' dynamic content from the 'List rows' action.

Was this reply helpful? Yes No
RmanNzrnk 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Afaik views is not supported im mysql actions. I've created view but can't access it in flow

upd:
i was wrong. mysql views supported. It cant't be selected in drop down list, but can be added manually - [dbname].[viewname].
Thank you @krootz

Was this reply helpful? Yes No