How to get all dates between two dates in power automate desktop

[Rampage]

What i need is, user will get input dialog box like Start Date and end date. After giving input all the dates between two dates will get store into the excel sheet.

for eg:

Start Date: 02-03-2022

End Date: 10-03-2022

Output:

[VJR · Accepted solution]

@Rampage 

Here is a sample process which you can customise as per your needs.

Copy-paste the below in a blank flow editor.

Display.SelectDateDialog.SelectDate Message: $'''From Date''' DateDialogFormat: Display.DateDialogFormat.DateOnly IsTopMost: False SelectedDate=> FromDate ButtonPressed=> ButtonPressed
Display.SelectDateDialog.SelectDate Message: $'''To Date''' DateDialogFormat: Display.DateDialogFormat.DateOnly IsTopMost: False SelectedDate=> ToDate ButtonPressed=> ButtonPressed
SET ResultedDate TO FromDate
Variables.CreateNewList List=> FinalList
LOOP WHILE (ResultedDate) <= (ToDate)
    Variables.AddItemToList Item: ResultedDate List: FinalList NewList=> FinalList
    DateTime.Add DateTime: ResultedDate TimeToAdd: 1 TimeUnit: DateTime.TimeUnit.Days ResultedDate=> ResultedDate
    DISABLE Display.ShowMessageDialog.ShowMessage Message: ResultedDate Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed2
END
Excel.LaunchExcel.LaunchUnderExistingProcess Visible: True Instance=> ExcelInstance
Excel.WriteToExcel.Write Instance: ExcelInstance Value: FinalList

Output after running the process.

You can work on the date formatting part in the flow.

You can close the thread if this is good enough for you to get going.

[Rampage]

Can you tell me where is the blank flow editor locate?

[VJR]

When you open the Power Automate Desktop tool, on the top left hand corner you will see "New flow" button.

Hope you are using the Power Automate Desktop tool and not the Cloud flows 😊. 

[Rampage]

Display.SelectDateDialog.SelectDate Message: $'''From Date''' DateDialogFormat: Display.DateDialogFormat.DateOnly IsTopMost: False SelectedDate=> FromDate ButtonPressed=> ButtonPressed
Display.SelectDateDialog.SelectDate Message: $'''To Date''' DateDialogFormat: Display.DateDialogFormat.DateOnly IsTopMost: False SelectedDate=> ToDate ButtonPressed=> ButtonPressed
SET ResultedDate TO FromDate
Variables.CreateNewList List=> FinalList
LOOP WHILE (ResultedDate) <= (ToDate)
    Variables.AddItemToList Item: ResultedDate List: FinalList NewList=> FinalList
    DateTime.Add DateTime: ResultedDate TimeToAdd: 1 TimeUnit: DateTime.TimeUnit.Days ResultedDate=> ResultedDate
    DISABLE Display.ShowMessageDialog.ShowMessage Message: ResultedDate Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed2
END
Excel.LaunchExcel.LaunchUnderExistingProcess Visible: True Instance=> ExcelInstance
Excel.WriteToExcel.Write Instance: ExcelInstance Value: FinalList

where to insert this code?

[VJR]

On the main screen of the Power Automate Desktop tool you will find the New flow button

Click on it which will open a new blank editor and paste the code there.

[Rampage]

Thanks for your help, its working

[Rampage]

why i am getting output like this?

expected output what i need is this:

[VJR]

Just add a date formatting action in the first line after the loop starts

Your list will be generated in the right format

and you will see the output as below

[Rampage]

But in here why its changing format after 12th row? 1-12 is in Number format and after that all are in text how to resolve this?

[VJR]

Delete that entire column (not just the text) and run the flow again or use a new excel file. 

[Guriga]

It's Excel. 

Until twelve it is in US format then it realizes 13 months is not valid so it changes to the correct UK format.

I have the same result.

BUT

If you reformat the excel sheet (set to text rather than general), open and save the data in it, it's working perfectly.