cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
petergriac
Helper II
Helper II

Get the last ID of Sharepoint list item to Powerapps

Hi!

I'm creating a record in PowerApps and saving it to Sharepiont List with Patch() function:

 

Patch(PhoneVacation, Defaults(PhoneVacation),
{Vacation_x0020_Type:Dropdown_Vacation.Selected.Value,Detail: Detail.Text,...

Now I want to get ID of the new item that is created in Sharepoint list and pass it to worflow. 

Does anyone knows how do I get the last item ID from sharepoint list back to PowerApps? 

Thanks a lot

1 ACCEPTED SOLUTION

Accepted Solutions
tchin-nin
Memorable Member
Memorable Member

Then you can try 

Refresh(PhoneVacation);
Set(LastAddedItem,First(Sort(PhoneVacation,ID,SortOrder.Descending)))

 Théo

View solution in original post

6 REPLIES 6
tchin-nin
Memorable Member
Memorable Member

Hi @petergriac

 

If you can consider using a SubmitForm function instead of a Patch, you can use the LastSubmit property of a form. 

 

SubmitForm(EditForm1)

EditForm1.LastSubmit.ID will return the ID of item you've just created. 

 

Théo

Thanks Theo.

Do you know if there is another way? I'm not using forms here.

tchin-nin
Memorable Member
Memorable Member

Then you can try 

Refresh(PhoneVacation);
Set(LastAddedItem,First(Sort(PhoneVacation,ID,SortOrder.Descending)))

 Théo

Thanks a lot, this works for me

@tchin-nin, how would I alter this code to get it to write to a column in a different sharepoint list?

Hi @tchin-nin 

Thanks, a lot man this really helped me a lot. Kudos to you expert. 

 

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (2,937)