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

Community site session details

Session Id : wWyvmk2vjQ3yzcgdtFbBFB
Power Automate - Building Flows
Unanswered

Passing 2 date parameters in Export to files for paginated report

Like (1) ShareShare
ReportReport
Posted on 18 Sep 2021 03:51:43 by 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. 

 

I have the same question (0)
  • PaddyWann Profile Picture
    101 on 19 May 2022 at 13:31:32
    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
    on 03 May 2022 at 18:10:51
    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
    242 on 23 Nov 2021 at 19:06:50
    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

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Loading started