Unanswered

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

(0) Share

Report

Posted on by 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:

Categories:

Power Automate Desktop

I have the same question (0)

All responses (11)

Answers (1)

Verified answer

VJR 7,635 on at

Like (0)

Report
@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.

Was this reply helpful? Yes No
Rampage 45 on at

Like (0)

Report

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

Was this reply helpful? Yes No
VJR 7,635 on at

Like (0)

Report

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 😊.

Was this reply helpful? Yes No
Rampage 45 on at

Like (0)

Report
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?

Was this reply helpful? Yes No
VJR 7,635 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Rampage 45 on at

Like (1)

Report

Thanks for your help, its working

Was this reply helpful? Yes No
Rampage 45 on at

Like (0)

Report

why i am getting output like this?
expected output what i need is this:

Was this reply helpful? Yes No
VJR 7,635 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Rampage 45 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
VJR 7,635 on at

Like (0)

Report

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

Was this reply helpful? Yes No