Increment ID column for multiple Rows

(0) Share

Report

Posted on by AyushPriyadarsh

Flow to develop :

1. Upload a excel to sharepoint ( col : id, name, status)

2. convert the excel into table

3. Read the rows from excel

4. Append all the rows of new excel in pre exisiting Master table. In doing this I want to update/increment the ID column based on previous data

Step 1,2 and 3 is done

In step 4 , I am facing issue : if in my already exisiting data, the last row id is 4 and I am appending 2 more rows then both of my rows ID are showing 5 instead of 1st row to be 5 and 2nd row to be 6. I tried adding a delay also but it doesnt work

Using output of compose in add a row into table

Help would be appreciated.

Thanks,

Ayush

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

v-yueyun-msft on at

Like (0)

Report
Copy link

Link copied!

Hi , @AyushPriyadarsh
If possible , can you try to close the Split on in the trigger's setting to test:
And you need to use the Apply to each action to loop to add a row in your table.

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
Verified answer

AyushPriyadarsh 9 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-yueyun-msft ,
Thanks for the response, but I found the solution.

Instead of finding the last row of my Master table inside the loop, I did that outside the loop and assigned to a variable "maxID" and then used increment variable property inside the loop.

This did the work for me 🙂

Regards,
Ayush Priyadarshi

Was this reply helpful? Yes No