web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : rrQna1vZS3PYT1HMombOQ8
Power Automate - Building Flows
Unanswered

Creating a Sharepoint item from Microsoft forms.

Like (0) ShareShare
ReportReport
Posted on 14 Sep 2023 05:24:05 by 33

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

ShayGur_1-1694668808871.png

 

  

  • BalajiSrini5133 Profile Picture
    6 on 14 Sep 2023 at 09:16:46
    Re: Creating a Sharepoint item from Microsoft forms.

    can you share the error screen shot?

  • ShayGur Profile Picture
    33 on 14 Sep 2023 at 06:19:24
    Re: Creating a Sharepoint item from Microsoft forms.

    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? 

  • BalajiSrini5133 Profile Picture
    6 on 14 Sep 2023 at 05:51:27
    Re: Creating a Sharepoint item from Microsoft forms.

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Loading complete