Unanswered

Creating a Sharepoint item from Microsoft forms.

(0) Share

Report

Posted on by ShayGur

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!!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

BalajiSrini5133 6 on at

Like (0)

Report
Copy link

Link copied!

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" .

Was this reply helpful? Yes No
ShayGur 33 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
BalajiSrini5133 6 on at

Like (0)

Report
Copy link

Link copied!

can you share the error screen shot?

Was this reply helpful? Yes No