Auto Increment ID number in Form Responses Tab Excel sheet

(0) Share

Report

Posted on by Marty3012

Hi,

Below is a sample view of responses gathered from a Form;

FLow 100.PNG

It is the Excel sheet that is available in the 'Responses' tab within the Form.

I realise that you can edit, delete etc in a Forms response excel sheet. However, what I'd like to do is add an auto incremental ID, every time a new response is submitted, like so;

FLow 1001.PNG

Adding the Column is easy of course, but I'm stuck on how to fill in the incrementall ID. I would prefer to use a Flow to do this if possible, rather than create an Excel function.

Thanks for any help

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-zhos-msft on at

Like (0)

Report

Hi,

According to your description, you want to add an increment number in the excel row when you add a row in the table from the form.

I have made a flow for your scenario, please check it for a reference.

Best Regards,

Zhongys

Was this reply helpful? Yes No
Tapesh_Patel 39 on at

Like (0)

Report

Hi Did you get the result as expected 1,2,3,4 if yes how ? will you help as i also have same issue while updating the records and the photos which is showed in solution dose not seems to work

Was this reply helpful? Yes No