[Question] Lookup last row

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello wonderful community,

I have a question concerning how to lookup the last row in a table when I don't know how many rows.

For example, I have the table below, with columns: ID, Ticket ID, First Name, Last Name, Company

Row 1 - JU192 - James - Antwan - Trans. INC
Row 2 - JU193 - Jack - Belford - XYZ INC
Row 3 - JU192 - Anthon - Jacks - Unierst INC
Row 4 - JU192 - Jimmy - McField - Standom INC
Row 5 - JU194 - Neo - McField - FieldMax INC

How can I look up the column Ticket ID = JU192 column Company, and to give me the last results which is Standom INC

Thanks 🙂

Categories:

Building Power Apps

All responses (14)

Answers (1)

Sort by

Mike8 1,330 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

I think you can't. 😛
Verified answer

Shanescows 2,218 Most Valuable Professional on at

Like
a
(15)

Report
Copy link

Link copied!

Thinking off the top of my head but I think you can.

Combine the Filter and Last functions.

Last(Filter(DataSource, Column = Value, ColumnYouWantToReturn).ColumnYouWantToReturn

In my head that is real close if not exactly what you need @Anonymous
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
@Shanescows is correct and I believe that would also be delegable in all of the following, one of which you are likely using

Common Data Service
SharePoint
SQL Server
Dynamics 365
Salesforce
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Pretty amazing 🙂 Thank you @Shanescows

And thank you guys for the support.

And @Mike8 😛
Mike8 1,330 on at

Like
a
(0)

Report
Copy link

Link copied!

Hehe. I am sorry. I misunderstood the question.
I am glad that Shanescows got it right.

You are welcome 😛
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

hi @Shanescows

tried this formula pulling up data from Sharepoint List but it returns no data found.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Shanescows

I used this but it gave me 0 result where it should be 54: Max(LookUp(Attendance_Tracker_15,Title = "ASP10986",UniqueID0))
Tangi12 32 on at

Like
a
(0)

Report
Copy link

Link copied!
@Shanescows I am trying to do this same thing, but utilizing the Created By field. (love your videos by the way) 🙂

I can't seem to get it to work.
Last(Filter('Model Branch Check In/Check Out',ThisItem.Title='Model Name','Created By'.DisplayName).'Created By')

At the end, I have tried 'Created By'.DisplayName and 'Created By'

Thanks for any help!!!!
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hello @Tangi12

I think first, you would need to write the Filter function properly:

Filter('Model Branch Check In/Check Out',Title='Model Name','Created By'.DisplayName = "John Smith")

Then add the Last function on it:

Last(Filter('Model Branch Check In/Check Out',Title='Model Name','Created By'.DisplayName = "John Smith")).'Created By'.DisplayName
kkmavro 7 on at

Like
a
(0)

Report
Copy link

Link copied!

I've tried ClearCollect into Sample and then Last on the containts of Sample. And worked... I wanted to show a popup screen with the last record after submiting a new form (let's say order No)