Use filter or Lookup to show a selected value connected to another table

(0) Share

Report

Posted on by RikardE

I posted this in connecting to data but figured it might get more response in the general discussion.

Please contact me if you don't understand the issue.

I have a Detailform which retrieves information from another screen.

So in this example I have pressed my Sales order "000002" and gets to my detail screen.

I have managed to get the "company" and "Sales order" data by using my DataSource "SalesOrderHeaders" and set the Item to "BrowseGallery2.Selected". (Which is the name of the screen where I selected my Sales order).

I also want to retrieve the Item number but this is from another table called SalesOrderLines. I want it to match with my Sales order number "000002".

Can I use Filter/Lookup to get data from my SalesOrderLines and match it with the Sales order number somehow?

Thanks for the help

Fel item.JPG

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

Meneghino 6,949 on at

Like
a
(0)

Report
Copy link

Link copied!

If there is a one-to-one relation then use LookUp, if one-to-many then use Filter.
Please let me know if you need details, but being specifc with the issue you are facing in using these functions (i.e. what you tried and what you got)
RikardE 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you,

Well, I have tried to do a filter but I can't get it to work.
Not sure if Im doing it correctly.

Filter(SalesOrderLines,SalesOrderHeader.SalesOrderNumber = BrowseGallery2.Selected.SalesOrderNumber)

So I want it to the get the SalesOrderLines that is connected to the SalesOrderHeader.
I chose the SalesOrderNumber in my BrowseGallery2.
Meneghino 6,949 on at

Like
a
(0)

Report
Copy link

Link copied!

Rikard, I suggest that we Skype next week (Wed-Fri) so I can show you what needs doing. I will send you a private message with my contact.
Mike8 1,330 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello RikardE,

Let's name the column of SalesOrderLines table that has the Item number that you need ItemNumber.

Does the following, work for you..?

LookUp(SalesOrderLines,ItemNumber= BrowseGallery2.Selected.SalesOrderNumber,ItemNumber)

(Replace ItemNumber with the actual name of your column)