How to set an auto-incremental ID to title column in sharepoint list

[Niels_T]

Hello,

I have a button that navigates me to the first page of a multi-screen lead form:

Set(varFormData,Defaults('Lead Form')); Navigate(Contact_Info_Page);

I have a field within my sharepoint microsoft list that is called Title and I would like to use this column to add id's that starts with 1 and gets incremented for each new row that is being added.

Would it be possible that whenever I click the "Create a new form" button that I immediately add a 1 to the Title column (and the next form 2, 3, ...)? 

[PG_WorXz10 · Accepted solution]

Hi @Niels_T ,

Yes, it is possible.  I assume you will be updating the current items Title record or you want to add new column with title value 1. 

IF update is required:  UpdateIf(DataSourceName,ID=YourSelectedITem.ID,{Title:1})


If New record:  Patch(DataSourceName,Defaults(DataSourceName),{Title:1})

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[eka24 · Accepted solution]

I have a tutorial on autoincrement:

https://youtu.be/wsaMirkf3Pc

Hope it helps

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.