Hey, I have a list of items purchased in my organization, and I want to create an automatic flow that adds items from a Microsoft form the employees can fill themselves.
Each asset has a numeric tag by chorological order of purchase, as you can see in the picture.
I wanted help finding out the best way to get the highest value (Last purchased item), increase it by 1, and then add the new purchase to the list. The employees doesn't have access to the list and can't fill the number themselves.
Thank you very much in advance!!
can you share the error screen shot?
Hey @BalajiSrini5133 ,
When I try to initialize a value, it automatically turns it into apply to each, which then causes error. How do I access the Asset tag number?
Hi @ShayGur ,
combine the below points with item store to the sharepoint list flow,
1. you need to get the last added item's ID through power automate action. Use "Get Items" action with "orderby" Created desc and Top count 1. Now you will get the Latest item id.
2. Now by using the item id you can get the "Asset tag" of that id. Store this value in variable by using set variable action and use increment variable action to increase the stored variable by 1.
3. By using Update item, you can store the asset tag value to the newly created item.
If you acheived your requirement through the above method, Please "Accept as a solution" .