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
Super User
Super User

Re: Get the last ID of Sharepoint list item to Powerapps

Then you can try 

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

 Théo

View solution in original post

5 REPLIES 5
Super User
Super User

Re: Get the last ID of Sharepoint list item to Powerapps

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 Helper II
Helper II

Re: Get the last ID of Sharepoint list item to Powerapps

Thanks Theo.

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

Super User
Super User

Re: Get the last ID of Sharepoint list item to Powerapps

Then you can try 

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

 Théo

View solution in original post

petergriac Helper II
Helper II

Re: Get the last ID of Sharepoint list item to Powerapps

Thanks a lot, this works for me

Highlighted
SilentStorm
New Member

Re: Get the last ID of Sharepoint list item to Powerapps

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

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (9,644)