Let's POWER Automate

From no-code to low-code

Menu
  • Expressions
  • Filters
  • General
  • Application specific solutions
    • Dataverse
    • Excel
    • Forms
    • Planner
    • Outlook
    • SharePoint
    • Teams
  • Triggers
  • Resources
  • ABOUT ME
  • Get help with your flow
Menu

Lookup data from connected Dataverse table with Power Automate

Posted on December 14, 2022December 14, 2022 by Tom

“How can I get data from another Dataverse table connected by a lookup column, what’s the best approach in Power Automate?”


When building solution over Dataverse, you might end up with multiple tables to store different type of information. Yet the information is often connected and the way to create such connection are lookup columns. There’s already a post on updating the lookup values using Power Automate, but how do you use them afterwards? What’s the best way to get the additional information from the second table?

You don’t need an additional action

Unlike with SharePoint where you need another ‘Get items’ action, in Dataverse you don’t need second ‘List rows’ (as long as there’s a lookup column). It’s because the ‘List rows’ action already offers such option in the ‘Expand Query’ field.

But what do you put there? As you might expect you’ll have to type in the input manually.

Use the Expand Query option

The input has always (at least) two pieces – the lookup column schema name and the data column logical name.

<lookupColumnSchemaName>($select=<dataColumnLogicalName>)

Firstly, you need the Schema name of the lookup column in the main table.

Secondly, you’ll need the Logical name of the column in the second table.

Once you have both the pieces, turn them into the ‘Expand Query’, e.g.

cr09b_LookupColumn($select=cr09b_anotherlookupcolumn)
Power Automate lookup dataverse table

If you need more columns from the same table, separate them by comma…

<lookupColumnSchemaName>($select=<dataColumnLogicalName>,<dataColumnLogicalName2>,<dataColumnLogicalName3>)

…or use the same approach to select columns from multiple tables.

<lookupColumnSchemaName>($select=<dataColumnLogicalName>,<dataColumnLogicalName2>,<dataColumnLogicalName3>),<lookupColumnSchemaNameX>($select=<dataColumnLogicalNameY>,<dataColumnLogicalNameZ>)

Summary

Power Automate allows you to get data from another Dataverse table connected by a lookup field without any extra actions. You don’t need to add another ‘List rows’ with a filter, but you must know what to enter in the ‘Expand Query’. Get the lookup column Schema name together with the data column Logical name, put it together, and collect related data across multiple Dataverse tables in a single action.


Do you struggle with the various expressions, conditions, filters, or HTTP requests available in Power Automate?

I send one email per week with a summary of the new solutions, designed to help even non IT people to automate some of their repetitive tasks.

All subscribers have also access to resources like a SharePoint Filter Query cheat sheet or Date expressions cheat sheet.

Zero spam, unsubscribe anytime.

2 thoughts on “Lookup data from connected Dataverse table with Power Automate”

  1. Ben says:
    July 12, 2023 at 12:08 am

    Can I hire you for 30 min to 1 hour? I need to filter a dataverse query using the label value (not the index) of a choice column.

    I would like to query dataverse and list the index and values of a choice list, but I can’t figure it out.

    Thanks…

    Reply
    1. Tom says:
      August 13, 2023 at 3:18 pm

      Hello Ben,
      yes, I do consulting sessions: https://tomriha.com/power-automate-consulting/

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Do you know what to do, but not how to do it?

Get The Ultimate Power Automate expressions cheat sheet and translate your thoughts into flows with ease!


There's also the HTTP requests to SharePoint cheat sheet to help you overcome limitations of some standard actions!

Do you struggle with the various expressions, conditions, filters, or HTTP requests available in Power Automate?

I send one email per week with a summary of the new solutions, designed to help even non IT people to automate some of their repetitive tasks.

All subscribers have also access to resources like a SharePoint Filter Query cheat sheet or Date expressions cheat sheet.

Zero spam, unsubscribe anytime.

Didn't find what you were looking for?
Need to adjust a solution to fit your needs?
Or would you just like to get an assistance from somebody with 1000s of hours of experience with Power Automate?

Power Automate blogs worth visiting

Damien Bird
Dennis (Expiscornovus)
Paul Murana

©2023 Let's POWER Automate | Theme by SuperbThemes