1

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.

2
  • What is the data type of columns you want to get in recommendation from lookup column? Aug 10, 2022 at 13:06
  • @GaneshSanap It's a single line of text (if I got the question right)
    – TT-txt
    Aug 10, 2022 at 13:09

1 Answer 1

1

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

enter image description here

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

enter image description here


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

2
  • Thanks for the answer, I am using that and it's now working, it's just not intuitive to have to go through those steps to make it work... Thanks again!
    – TT-txt
    Aug 10, 2022 at 13:26
  • You're welcome, glad it worked for you! Aug 10, 2022 at 13:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.