Answered

How to Create Array of numbers 0 to x via expressions - sequence()?

(0) Share

Report

Posted on by rjtedge

Hi,

I am assuming that the sequence() expression function does not work with flows? I would like to dynmically create an array of numbers based on the returned value for an api call but can't work out what the expression looks like.

Thanks

All responses (5)

Answers (1)

tfraser 177 on at

Like (1)

Report

Re: How to Create Array of numbers 0 to x via expressions - sequence()?

It's a long time since this was asked but for anyone else looking for this in future I achieved this by first adding a 'compose' step with a range(start,count) expression then multiplying each item in the range by a factor equal to my desired interval using a 'select' step.

This is very quick compared iterating a value and adding it to an array using a loop.
Verified answer

v-bofeng-msft on at

Like (0)

Report

Re: How to Create Array of numbers 0 to x via expressions - sequence()?

Hi @rjtedge :

Power Automate currently does not have a function similar to sequence() in Power Apps.I am not sure how to achieve your needs through API, but I have an alternative method

I've made a test for your reference:

1\My Flow

2\Run the flow

3\The result:

Best Regards,

Bof
Paulie78 8,416 Super User 2025 Season 1 on at

Like (0)

Report

Re: How to Create Array of numbers 0 to x via expressions - sequence()?

Either parameter can be dynamically driven by the output from previous steps. So you can use the value coming back from your API.
rjtedge 4 on at

Like (0)

Report

Re: How to Create Array of numbers 0 to x via expressions - sequence()?

That's a great start. Is there any way to change the interval so that the array is (0,10,20,30) etc?
Paulie78 8,416 Super User 2025 Season 1 on at

Like (0)

Report

Re: How to Create Array of numbers 0 to x via expressions - sequence()?

Use the range expression:

range(0,10)