Note: Please do it using Microsoft Power Automate

Suppose we have a Sharepoint list with columns as, where Name and location are already filled with some values. We have two choices for types that is Buy and Sell. Now what i want is that when I select Buy, it automatically generated a unique ID 2000 and increments it by 1 as we have more buys in more columns. Now when we have Sell, I want the unique id to start from 5000. I will present an example. Suppose we havent filled type yet and the data looks like this. I have 4 entries in the list but we want to have as much entries as we want.

Name Location UniqueID type

x y

z m

s t

u v

Now when we select buy or sell, the table should look like this

Name Location UniqueID type

x y 2000 Buy

z m 5000 Sell

s t 2001 Buy

u v 5001 Sell