Unanswered

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

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Paulie78 8,422 Moderator on at

Like (0)

Report

Use the range expression:

range(0,10)

Was this reply helpful? Yes No
rjtedge 4 on at

Like (0)

Report

That's a great start. Is there any way to change the interval so that the array is (0,10,20,30) etc?

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No
SurfaceWear 186 on at

Like (1)

Report

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.

Was this reply helpful? Yes No