cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MiniMe_83
Helper IV
Helper IV

Create Consecutive Number list

Hi,

 

Hopefully someone can point me in the right direction.

 

I’m looking for a way to extract a list of dates between two known dates within a power automate flow? The flow will update an SP List which is connected to a PowerApp.

 

Example:

 

Known Starting Date: 01/01/2022

 

Known End Date: 05/01/2022

 

The Result I need:

 

02/01/2022

03/01/2022

04/01/2022

 

Both Start and the End dates are in ISO8601 format if that helps and I can identify the days difference, I just can’t figure out how to get the dates in between.

 

Edit: It doesn’t need to be a date, if it makes it any simpler. Finding the numbers between two known numbers could also work.

 

Example: 

Known number1: 5

 

Known number2: 10

 

Result: 

 

6

7

8

9

 

Thanks for your help on this.

1 ACCEPTED SOLUTION

Accepted Solutions
MiniMe_83
Helper IV
Helper IV

May have answered my own question by using the sequence function:

 

sequence(KnowNumber1,Number difference)

 

Im just not sure if this can be used in an expression in variable in a flow. Will see tomorrow. 

Please comment if I’m barking up the wrong tree! 

Thanks

View solution in original post

1 REPLY 1
MiniMe_83
Helper IV
Helper IV

May have answered my own question by using the sequence function:

 

sequence(KnowNumber1,Number difference)

 

Im just not sure if this can be used in an expression in variable in a flow. Will see tomorrow. 

Please comment if I’m barking up the wrong tree! 

Thanks

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (1,138)