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:

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-yueyun-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
KooiJit 28 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No