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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Display data by relate...
Power Apps
Answered

Display data by related table

(0) ShareShare
ReportReport
Posted on by 92

Hello everyone

I use Lookup related table and not showing errors but no display data what i want

example: i have 3 table

 Order (table 1) that including Customer (lookup from Account (Table 2) 

and Invoice (table 3) that Lookup from Order (Table1) (Order No Column)

in invoice form i want related table for customer: 'Account Name'

i use this formula

 

LookUp('Order', Customer.'Account Name' = Gallery3.Selected.'Order No'.'Order No', Customer).'Account Name'

 

It is No error but still no showing data in Customer field

 

Can i get help whit this formula

 

 

 

Categories:
  • Verified answer
    MudassarSZ365 Profile Picture
    591 on at

    try this 

    LookUp(Orders, 'Order No' = Gallery3.Selected.'Order No', Customer).'Account Name'
  • maheralkhalil Profile Picture
    92 on at

    Hi 

    thanks for your interest 

    yes that what I was looking 

    ‘order no’ it’s the lookup key

    but it’s working with

    lookup(Orders, ‘Order No’ =

    Gallery3.Selected.'Order No'.'Order No', Customer).'Account Name'

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 395 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 260 Most Valuable Professional

Last 30 days Overall leaderboard