Auto Increment ID using Flow correctly 2 hours ago
I have a list with bunch of columns but one column is ID Number which will have custom id RP1-001, RP1-002 like so on so forth, i have 121 records, i have loaded them in the list so last record ID number is RP1-121 and SharePoint list item id is 121. The question i have is how can i use flow to auto increment this id every item when a new item is created? and how to check if an item is deleted, it should increment accordingly, like if an item is added the ID number is RP1-122 and list item id is 122 and lets say someone deleted it, the next item item is added it should be RP-123 , because list item would be incremented automatically to 123, can we do that kind of checks in MS flow? and the whole idea of linking ID Number to out of the box list item id is the right way of approach? please let me know.