News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Display data by relate...

Power Apps - Building Power Apps

Answered

Display data by related table

(0) Share

Report

Report

Posted on by maheralkhalil

92

Hello everyoneI 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

All responses Img

All responses (2)

Answers Img

Answers (1)

maheralkhalil 92 on at

Like (0)

Report

Re: Display data by related table

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'
Verified answer

MudassarSZ365 591 on at

Like (1)

Report
Re: Display data by related table

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