Answered

Auto numbering in column

(0) Share

Report

Posted on by KooiJit

Hi, I have two outputs from two 'Select' actions. Both have the same columns. For output from the 'Select A' action, I want to add numbering in the column 'Line', starting from 1 until the end of the active rows (the table rows are not static.). For the output from the 'Select B' action, the numbering will follow the last number in the 'Select A' output.

I did combine the two outputs using 'Union' under 'Compose' action. I am not sure if the numbering can be done after the 'Compose' action or during the 'Select' action.

Any insight is very much appreciated. Thank you.

My flow:

All responses (2)

Answers (1)

KooiJit 28 on at

Like (0)

Report

Re: Auto numbering in column

Omg, you saved my day!

It works! I never knew it could be done like this.

Thank you so much for your prompt reply and help! Really appreciate it.
Verified answer

v-yueyun-msft on at

Like (1)

Report

Re: Auto numbering in column

Hi , @KooiJit
According to your description, you want to auto numbering in your array .
This is my test array, which is similar to your select action output , here we do not need to add the Index column.
Then we can use this action to add the Index Column:

range(0,length(outputs('Compose_3')))
outputs('Compose_3')?[item()]?['Document']
outputs('Compose_3')?[item()]?['Count']
add(item(),1)

Best Regards,
Yueyun Zhang