web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : XPYzG2d4BOYUdz/2mOvuk1
Power Automate - Building Flows
Answered

Lookup data from getrow action

Like (0) ShareShare
ReportReport
Posted on 10 Nov 2020 15:51:30 by 6

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.

  • RmanNzrnk Profile Picture
    6 on 11 Nov 2020 at 07:46:24
    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  

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

    image.png

  • Verified answer
    krootz Profile Picture
    458 on 10 Nov 2020 at 20:39:38
    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.

  • ChristianAbata Profile Picture
    8,949 Most Valuable Professional on 10 Nov 2020 at 20:31:34
    Re: Lookup data from getrow action

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

     

    excel.PNG

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Loading complete