web

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

News and Announcements icon

Power Platform CommunityForums Power Apps How to find last submi...

Power Apps

Unanswered

How to find last submitted item by user in SharePoint list?

(0) Share

Report

Report

Posted on by Dave Wi

Hello,

Edit form is submitting an item into the SharePoint list, How do I get the submitted list item in OnSucess attribute of edit form?

As "Form.LastSubmit" doesnt work for SharePoint list AND

First(Sort(colItems,ID,SortOrder.Descending)) -- might not give the correct item due two concurrent submission?

any clue?

Thanks,

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

CU-18081211-6 9,270 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @dave8 ,
I'm not sure what you want to achive. The function LastSubmit retrives the last succesfull record send throught the form to sharepoint. Form.LastSubmit should work inside OnSuccess property of the form.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi@dave8,
Based on the issue that you mentioned, do you want to display the last submitted item once you submit the form?
Could you please share a bit more about the scenario?
Actually, if you use Form.LastSubmit, the item will be captured with the corresponding ID. If you just want to get the last submitted item, you could add a Gallery to display it.
However, the acquisition of Form.LastSubmit attribute is not particularly stable, I think you could try to refer to the 'Modified'
I have a test on my side, please take a try as below.
Add a Gallery and set the Items property as below:

First(Sort(Test1029,Modified,Descending))

Now the item within the Gallery is the last submitted item.
You can set the Text property of the Label to display whatever you want.

ThisItem.ColumnName

Note: 'Test1029' is my SP list name, please replace it with yours.
Best Regards,
Qi

Was this reply helpful? Yes No

Join the conversation