web

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

News and Announcements icon

Power Platform CommunityForums Power Apps collect or set variabl...

Power Apps

Answered

collect or set variable to show last item ID only

(0) Share

Report

Report

Posted on by StuCundy

377

Hi there

I have a sharepoint list of images and wish to show the last submitted ID in a collection or variable.

Currently I have a collection called ImageID showing the ID's

ClearCollect(ImageID,'Images-test'.ID,Sort('Images-test',ID, SortOrder.Descending))

I only need the last ID submitted and do not want to receive any others.

Is there any easy way?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

mdevaney 29,991 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!
@StuCundy

This code will retrieve the last record submitted to a datasource

Set(varLastRecord, First(Sort(your_datasource_name, ID, Descending)))

To obtain the ID of the LastRecord use this code

varLastRecord.ID

---
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."

Was this reply helpful? Yes No

Join the conversation