I use power automate to send personalized excel file to a list of emails.

[anto_n]

I use power automate to send excel file to a list of emails. It is export from paginated report. how to fliter results based on an email provided in the list using step "Initialize Vriable" that i have created for the list of emails. In the report I have a column with email I want to filter. My flow works, but it sends all the data to everyone. Send Power BI report as excel via email using Power Automate 

[lbendlin · Accepted solution]

Specify the parameter values accordingly

[v-sathmakuri]

Hi @anto_n ,

Thank you for reaching out to Microsoft Fabric Community.

As this is microsoft fabrics forum, i would suggest raising a ticket is power automate forum for faster resolutions. 

Forum Linke : https://community.powerplatform.com/forums/thread/?groupid=46ce02a3-e1a7-4176-81fc-d93a4001d287 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

[lbendlin · Accepted solution]

Specify the parameter values accordingly

[anto_n · Accepted solution]

Tank you for the promt reply!

I successfully configured my paginated report to set parameters for email and then used the ParametersValue option in "Export to File for Paginated Reports." Now, I can send Excel files containing data specific to each user.