Answered

Find the last record that match a name from another column

(0) Share

Report

Posted on by Sabier

Hello;

I'm creating an app to help keep track changes of product container, each product container has a different lot number, but will have the same name.

What I want to do is to show the lot code of the last product name that was used before replacing it for a new product container.

The table looks like this.

product -name	lot-number
product1	1234
product2	1235
product3	1236
product2	1237
product1	1238

I would like to find product product2 and return on the text box the lot code that will be 1237, but my current formula just return the first record matching that name.

If(Dropdown1.Selected.Value ="Old Container",LookUp(dataSource,product-name = Dropdown2.Selected.Value,lot-number) & If(Dropdown1.Selected.Value = "New Container", ScanResult))

The search will be based on the Dropdown2 value.

Thanks for your help.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,421 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Sabier ,

Try this - note the With() statement is only to avoid a Delegation warning on the First() statement

With( { wProduct, Sort( Filter( dataSource 'product-name' = Dropdown2.Selected.Value ), 'lot-number' Decending ).'lot-number' }, First(wProduct) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Vijay Tailor 2,961 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Sabier ,

as per my understanding see the below approach.

Hope to help you to resolve your issue.
use the Filter Instead of Lookup and so you can sort data based on the last ID like descending ways.
First(SortByColumns(Filter(TestAkshay,MyUser.DisplayName<>Blank()),"ID",Descending))

Thanks,
Vijay
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."-Vijay

Was this reply helpful? Yes No