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?

I have the same question (0)

All responses (8)

Answers (0)

Community Power Pla... on at

Like (0)

Report

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

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 68,271 Most Valuable Professional on at

Like (0)

Report

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

Can you show me the flow you are using?

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

Like (0)

Report

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

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 68,271 Most Valuable Professional on at

Like (1)

Report

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

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... on at

Like (0)

Report

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

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

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

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

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

@jags1 did you find any solution to this?

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

Like (0)

Report

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

Hi @jags1 Did you found the answer?

Was this reply helpful? Yes No