Hi
You can try with Variables, Do Until, adddays() array() and union(). Both adddays() array() and union() are functions defined here https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language
Let's assume you have stored the StartDate inside a variable called the same. Also for EndDate. I guess both dates shall be defined in datetime string which match ISO 8601 format ('o'), in order to apply adddays() function later on.
So, you initialize two array variables (myArray and auxArray) with the following expression:
array(variables('StartDate'))
You also initialize two string variables (indexDate and auxDate) with the following dynamic content:
variables('StartDate')
then you add the Do Until loop:
set indexDate to the following expression:
adddays(auxDate,1)
set auxDate to the following dynamic content:
variables('indexDate')
set myArray to the following expression
union(auxArray,array(variables('indexDate')))
set auxArray to the following dynamic content:
variables('myArray')
The Do Until shall be stopped once you reach the following condition:
equals(variables('EndDate'),variables('indexDate'))
In case it's needed, there is an intesting thread explaining how to match ISO 8601 format ('o') here:
https://powerusers.microsoft.com/t5/Building-Flows/formatDateTime-to-ISO-8061-format-for-Create-Even...
I haven't tested it myself, let's hope I haven't missed and single quote, parenthesis etc.
Hope this helps
Each time you click on any of our inspiring answers 'Thumb up' icon......an ewok scapes from the stormtroopers.
Be grateful, Thumbs up! Save the Galaxy for free! Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/
Proud to be a Flownaut!