Filter Columns with Fields Parameter and Export Data to CSV using Power Automate Button

[HerNameIsWhat]

Hello

I have a fields parameter slicer were the user can select fields to display on a table and after the user can export that data to csv using a Power Automate button.

I Cant seem to figure out how to have the data/columns dynamically filter based on whats selected on the fields parameter , My current export includes all the fields no matter what is selected on the slicer.

Is there a way for the user to export only the fields selected on a fields parameter

Please see sample data below:

Fields parameter slicer:

• Name
• Last Name
• email
• CellPhone
• Position
• Staff Number

user only selects the fields below shown in the table and export these to csv file (please note these are dynamic user can select any fields on the slicer)

Name	last name	email	cellphone no
kate	smith	smith@yahoo.com	0123456776
June	Jackson	Jackson@yahoo.com	0891011126
April	Fools	Fools@yahoo.com	0314151617

Thanks for the Help

[Anonymous · Accepted solution]

Thanks for the reply from audreygerred , please allow me to provide another insight: 
Hi  @HerNameIsWhat ,

First you can try to create a Power Automate visual of the Power BI report, trigger the Power Automate flow through the button, and pass the PBI visual data under the current contextual filtering conditions to Automate to do the creation of the csv table.

Create a Power Automate visual for Power BI - Power BI | Microsoft Learn

Use data operations in Power Automate - Power Automate | Microsoft Learn

After that you can try to use SharePoint action to save the data in SharePoint, and finally use Outlook action to send an email to the user, or you can include the corresponding .csv file in the email attachment.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[audreygerred]

Hello! When I have a visual that uses field parameters and export the data, only the data showing in the visual exports. All I do is hover on the visual, select the three dots, select export data and choose whether I want it to be .xlsx or .csv. Only the items I have chosen from the field parameter and the measures that I have in the visual export. It does not include items that the user did not select from the field parameters.

[HerNameIsWhat]

Thanks for the reply, I’m aware of that option but for this requirement, I'm trying to automate the process for getting the data, how it's supposed to work is the user selects the fields and exports the data to a CSV file that is stored on SharePoint and then an email gets sent out to specific users that the data is available for them to use.