I'm a little bit stuck at the moment with a Paginated report and Flow. I have a Power BI paginated report that uses location codes to filter a parameter location and then a Flow that emails each report to any user that appears on a SQL table row with that location code. For these purposes, this works very well with Flow building the Paginated report, filtering paramaters by code, and sending it to corresponding location manager's email.
However, this is problematic for users like district leadership, who need a report for more than one location, as each instance of their email prompts Flow to send an additional email (some managers receiving up to 27 emails in the morning). The paginated report uses page breaks within the grouping to separate each location when more than one facility is selected, so manually, I can create an export that is Sheet-separated by user in the excel output.
So the question is, how do I communicate to Power Automate to select multiple rows for a single parameter if the user's email is duplicated in the SQL table? I'm happy to rebuild my table for rethink how the report does grouping if needed.
I hope this isnt confusing, but any help would be appreciated. (p.s. I'm using Power BI Paginated rather than classic SSRS because we use data available on the Power BI Service in a standardized Dataset)
