Unanswered

Power Automate - How to pass Select ALL parameter to Paginated report?

(1) Share

Report

Posted on by jags1

Paginated report has some of the parameters with select ALL option. Report runs fine but when run from Power Automate gives below error for those parameters which have Select All as values.

"One or more parameters required to run the report have not been specified. Some parameters do not have valid values. Values provided for one or more parameters are not valid."

How to pass this value from Power Automate to Paginated report?

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello @jags1 ,

I am facing the same issue. Have you already got the solution for this?

Thanks in advance

Was this reply helpful? Yes No
Pstork1 69,483 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Can you show me the flow you are using?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I just have here simple flow. I want to export the paginated report with various parameter values. In one of the parameter, I wanted to use select all options. In report builder, it works perfectly fine. When I use the "Select All" parameter value in Power Automate, gives me an error.

Was this reply helpful? Yes No
Pstork1 69,483 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

I suspect its because "Select All" isn't actually a parameter, its a setting in Report Builder. Have you tried setting "Select All" as the default for the Report and calling it from Power Automate without a specific Parameter? I'm not a Power Builder expert, but that's what I would try. Your only other choice would be to define all the specific parameters in Power Automate instead of submitting Select All.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Yeah, tried setting "Select All" as default in report builder and called it in Power Automate without parameter value, which gave me the error. Yeah, I could do it by specifying all values, but that's list is bit long.

thanks for your support!!

Was this reply helpful? Yes No
jags1 4 on at

Like (0)

Report
Copy link

Link copied!

Defining specific parameters is NOT an option considering it can be dynamic based on data fetched from a query.

Was this reply helpful? Yes No
TWolsten 108 on at

Like (0)

Report
Copy link

Link copied!

@jags1 did you find any solution to this?

Was this reply helpful? Yes No
hillel-romero 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @jags1 Did you found the answer?

Was this reply helpful? Yes No