Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Answered

Add number using flow

(0) ShareShare
ReportReport
Posted on by 39

Hi i want to use flow which will increment the number by its value to 1 every time user submits the new response using form, 

 

 

does anyone know how?

 

im trying to use this,

 

Untitled.png

 

but evry time i get the same number 1,1,1,1, where as i want 1,2,3,4, to be updates, 

can this be done by using any other functionality, like using add Match function, and if yes how. Thanks for help

  • Verified answer
    v-alzhan-msft Profile Picture
    on at
    Re: Add number using flow

    Hi @Tapesh_Patel ,

     

    Already offer a solution in the link below and please reply to this link if you have any problem:

    https://powerusers.microsoft.com/t5/Using-Flows/Auto-Increment-ID-duplication/m-p/518841/highlight/false#M13160

     

    I would offer you the workaround to create a new sharepoint list with a Number type column, and create an item in the list with the Number column save the initial value and update the value once a form response is submitted.

     

    Steps:

    1. Create a new list "ListNew" with a Number type column Name "Number", create the first item in the list with the Number column set to 1000, the id of this item would be 1 since this is the first item in the new list, the screenshot of the list as below:

    1.png

    2. Create a flow to add a new item for the new response when the response is submitted as my screenshot below:

    1.png2.png

    The flow would get the Number from the listNew, append 1 to the number and use the number to create new item in the list that you need, then update the Number with value(already append 1) in the list.

     

    Hope the solution could help you.

     

    Best Regards,

    Alice

     

    Community Support Team _ Alice Zhang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • ScottShearer Profile Picture
    25,208 Most Valuable Professional on at
    Re: Add number using flow

    @Tapesh_Patel 

    Please expand the two variable actions as well as the Update item action and post a screen shot.  That will be a big help to those trying to assist.

     

     

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,645 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,997 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow