Get the last ID of Sharepoint list item to Powerapps

[petergriac]

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

[tchin-nin]

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

[petergriac]

Thanks Theo.

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

[tchin-nin · Accepted solution]

Then you can try 

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

 Théo

[petergriac]

Thanks a lot, this works for me

[SilentStorm]

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

[Tapesh]

Hi @tchin-nin 

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