![]() If we are using Modern SharePoint Online list then we can also use simple Microsoft Flow to create auto-generate no for a list based on the Item ID. } Create auto increment column in SharePoint list using Microsoft Flow LastItemID = int.Parse(colItems.ToString()) ĬurrItem ="PNR-000-" + LastItemID + 1 SPListItemCollection colItems = list.GetItems(objQuery) public override void ItemAdded(SPItemEventProperties properties)īool allowUpdates = web.AllowUnsafeUpdates We can also create an auto-generate no in Item added event receiver in the SharePoint list but we need to find the last Item ID and based on that we will increment the no by 1 and update in the autogenerate field. ![]() Create auto increment column in SharePoint list using Event Receivers Note: For my point view we shouldn’t use calculated column here because the ID will be created after Item will be created so once you insert an item in a list, it will show your wrong value in the list, again you have to refresh the list, if you want to see the exact value in the autogenerate field. Auto generate id column in sharepoint 2013 lists
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |