
Announcements
I created a flow that generates a new excel file with custom columns etc. but I need to fill them with dates of current month
This needs to be my output:
This is for 'May' = First column is filled with dates and second column with days from given dates (grey fields are weekends). It is for a month report.
For now I extracted the days of the current month into an array using select but don't know how to fill the rows with it, I am wondering how to extract 1 row = 1 day from array of days.
Output for every day of the current month (In this case : July)
I suppose I need to disassemble the array and use APPLY TO EACH or something like that?
Any help would be much appreciated.
Okay, this did the trick:
Output in Apply to each is the output of the 'Select2' Array from the question above.