web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Finding Last Value in ...

Power Apps

Answered

Finding Last Value in Sharepoint

(0) Share

Report

Report

Posted on by CU06081315-1

Hello,

I'm trying to pull the last instance of a value by Sharepoint ID. I'm using a text input with the following formula to pull the ID:

LookUp('Change Log',And(RequestID=ReqID.Text, New_Value="Pending Approval"),ID)

In the test data I'm using, this provides me with ID 619, which is the lower of the two rows with this value. ID 622 is the other.

When I attempt to add a "Last" function to the formula, I get errors that it's expecting a text value. The syntax I'm trying to use is:

Last(LookUp('Change Log',And(RequestID=ReqID.Text, New_Value="Pending Approval"),ID))

Any advice on this?

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @cborde3,

LookUp will fetch the first record that matches the condition. You could Sort() your list based on the Created column descendingly and then use the LookUp function:

LookUp( Sort('Change Log', Created, SortOrder.Descending), RequestID = ReqID.Text && New_Value = "Pending Approval" ,ID )

Alternatively, you could fetch all corresponding records via a Filter function and select the last ID from the returned output:

Last( Filter( 'Change Log', RequestID = ReqID.Text && New_Value = "Pending Approval" ).ID )

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!
CU06081315-1 on at

Like
a
(0)

Report
Copy link

Link copied!

The first solution did the job, thank you!

Join the conversation