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

Using lookups with calculated fields

Like (0) ShareShare
ReportReport
Posted on 5 Aug 2023 03:47:21 by 31

I have a custom table that I'd like to add a field to that concatenates the values from a related row in another table. For example, in a table that contains line items for an order, I want to add a field that displays the name and description of an item. The name and description exist on the Items table.  The 'Line Item' table has a relationship connection to the Items table and the Orders table.

 

My first instinct is to create a calculated field that concatenates the item name and item description, but I'd like to avoid adding those columns to the 'Line Items' table if possible.

 

What's the best way to accomplish this? 

  • Verified answer
    steeevid Profile Picture
    321 Super User 2024 Season 1 on 05 Aug 2023 at 07:02:04
    Re: Using lookups with calculated fields

    Not sure how the relationship in your system works, it sounds like you have 3 or 2 tables?

     

    Anyway, use power fx formula column in the target table:

     

    formula example:

     

    concatenate('Item'.name, 'Item'.description)

     

    feel free to add any fixed seperator in the concatenate function to divide the text

     

    Never use calculated field, they are **bleep**

     

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Featured topics

Loading complete