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
How can I look up the column Ticket ID = JU192 column Company, and to give me the last results which is Standom INC
Solved! Go to Solution.
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)
I'm trying the same thing. This formula works, it shows me the last record in the SharePoint list:
Last('1. ISQC 1 Quality Control').'Who is ISQC?'
Now I want to add a Filter. So I can filter on the Firm. But I get errors. I used the same formula as @Shanescows
Last(Filter('1. ISQC 1 Quality Control', 'Firm'= Firm.Text, 'Who is ISQC?').'Who is ISQC?'
But when I try to use this I get the following error:
"the formula contains parenclose where eof is expected"
Am I missing something?
Thanks in advance!
I have tried Shanes suggestion and it works in general but does not work when trying to bring back a choice field. (I am working of a Sharepoint list)
My formula is like
Last(Filter(DataSource, Column = Value, Column.Value)).Column.Value
Keep up to date with current events and community announcements in the Power Apps community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!