Power Automate to create auto increment from list rows

(0) Share

Report

Posted on by tracycccc

Hi all,

I plan to use automate to create auto increment from 1 based on the list rows, and from 1 to 256 rows the automate is exactly right. However, when the number reaches 257 no matter how many times I add rows it will always be 257 and never increase to 258,259......

Can you help me to solve this problem? Thanks so much!

The follwing is my automate:

The Compose is

length(outputs('List_rows_present_in_a_table')?['body/value'])

The variable is

concat('HKTW-DN-',add(1,length(outputs('List_rows_present_in_a_table')?['body/value'])))

The wrong result is

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

v-xiaochen-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @tracycccc ,

Please try to set Top Count to 5000.

Best Regards,

Wearsky

Was this reply helpful? Yes No
tracycccc 42 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-xiaochen-msft ,
I just set the top count to 5000, but the result remains 257.

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft on at

Like (1)

Report
Copy link

Link copied!

Hi @tracycccc ,

Please turn on pagination.

Best Regards,

Wearsky

Was this reply helpful? Yes No
tracycccc 42 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-xiaochen-msft ,
It worked! Thank you so much!!!!!!

Was this reply helpful? Yes No