Parameter to Pass to Paginated Reports

I created a Power Automate flow to pass parameters to a Paginated Report, export the report, and send an email every month. My flow worked fine last month, but when I tested it this month it has failed and I can't seem to fix it.

I have a formula to return the Fiscal Year: if(greater(int(utcNow('MM')),9), add(int(utcNow('yyyy')),1),int(utcNow('yyyy')))

This formula returns an integer. My Paginated Report has one dataset for Fiscal Year - one column is composed of integers in YYYY format. The other column is the text in my dataset - FY23.

The Paginated Report parameter is formatted as text - the integer value is what the user selects, and the text is what is returned. The report works fine when I run it in Paginated Reports, but the Power Automate flow repeatedly fails and provides the error: "RootActivityId(8bbecd6d-77f3-4614-9e41-f01c3dd10c4f): Some parameters do not have valid values. Values provided for FY that are not valid include 2023."

I've tried changing the data in my paginated reports to all string and I've tried changing the power automate values from integer to string - but I still get the error (above). It must be something in Power Automate, either passing the parameter or creating the parameter, because the report itself works just fine.

Quick Links