web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / (Working with Arrays) ...
Power Apps
Answered

(Working with Arrays) / Fill excel rows with days/dates of current month with power automate

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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:

Toncilo_0-1657542094075.png

 

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)

Toncilo_1-1657542210917.png

 

 

I suppose I need to disassemble the array and use APPLY TO EACH or something like that?

 

Any help would be much appreciated.

 

 

Categories:
  • Verified answer
    Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Okay, this did the trick:

    Toncilo_0-1657544974841.png

    Output in Apply to each is the output of the 'Select2' Array from the question above.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 395 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 260 Most Valuable Professional

Last 30 days Overall leaderboard