Retrieve information from Lookup field (SharePoint list) in power automate

Question

I am trying to create an automation in power automate, triggered when a table A is edited.

Unfortunately, multiples values of that table are lookups, getting their data in other tables.

When trying to use the values from the lookups in power automate, those fields are not appearing in the "dynamic content" recommendation.

I was wondering if there is any way to retrieve the values from those fields directly?

Thanks for the help, I am new to those topics.

I can provide screenshots to explain in another if needed.

Answer 1

You have to show additional fields in lookup column settings like:

Then you can get those columns in "dynamic content" like:

---

Note: You can only extend below data types from lookup:

• Single line of text

• Number

• Date and Time

• Lookup (single value)

Documentation: Create list relationships by using lookup columns