Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Passing 2 date paramet...
Power Automate - Building Flows
Unanswered

Passing 2 date parameters in Export to files for paginated report

(1) ShareShare
ReportReport
Posted on by tracytran 144

Hi guys, 

 

I created a flow to export excel file on OneDrive and send the exported file as attachment like this: 

 

tracytran_0-1631936707524.png

 

It worked well when my paginated report does not have any parameter. However, now I have 2 parameters as follows: 

 

tracytran_1-1631936841593.png

 

How could I pass the StartDate and EndDate parameter in Export files for paginated report?? 

 

tracytran_2-1631936916207.png

 

What I want is to export the data LAST MONTH. For example: this month is Sep, I would like to get raw data in Aug. 

 

Could anyone please help me regarding this problem?

 

Any help is highly appreciated. 

 

  • PaddyWann Profile Picture
    PaddyWann 101 on at
    Re: Passing 2 date parameters in Export to files for paginated report

    same here. I had to make the field text in order to pass a parameter. I'm sure there's a formatting method in the report maker that can be done to make a format users can use. 

  • Luke G Profile Picture
    Luke G on at
    Re: Passing 2 date parameters in Export to files for paginated report

    I'm trying to do something very similar. I can figure out how to get the previous month, but not how to format the date the way the parameter wants to receive it!

    1st day of previous month: startOfMonth(addDays(startOfMonth(utcNow('mm/dd/yyyy')),-1)

    1st day of current month: startOfMonth(utcNow('mm/dd/yyyy')) (you could also do startof month -1 day to get last day of previous month)

  • nich3play3r Profile Picture
    nich3play3r 240 on at
    Re: Passing 2 date parameters in Export to files for paginated report

    Could you create variables in the flow to hold the start date and end date of the prior month and then use those values in your ParameterValues Value fields? Then, no matter when the flow ran, it would return report data from the prior month based on your variable values.

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans