Lookup data from getrow action

Like (0) Share

Report

Posted on 10 Nov 2020 15:51:30 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.

I have the same question (0)

All responses (4)

Answers (1)

RmanNzrnk 6 on 11 Nov 2020 at 07:46:24

Like (0)

Report

Re: Lookup data from getrow action

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
tom_riha 10,127 Most Valuable Professional on 10 Nov 2020 at 20:41:38

Like (0)

Report

Re: Lookup data from getrow action

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
Verified answer

krootz 458 on 10 Nov 2020 at 20:39:38

Like (0)

Report

Re: Lookup data from getrow action

@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
ChristianAbata 8,949 Most Valuable Professional on 10 Nov 2020 at 20:31:34

Like (0)

Report

Re: Lookup data from getrow action

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

Was this reply helpful? Yes No