Power Platform Community Forum Thread Details

Hi All,

Im trying use forms and flow together, when the form response has submitted the ID in excel on Splist should be updated by 1 after every new response submitted. However, i found that we can use the increment variable to acheive this, but while im trying to update the file after the response submitted, the variable is showing me same duplicate value.

i want results to be 1,2,3,4,5 and so on

Please see screen shots: Flow1 Flow1 Flow2 Flow2Sharepoint List

Categories:

Using flows

Hi @Tapesh ,

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:

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

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.