Forum Discussion
Filter Columns with Fields Parameter and Export Data to CSV using Power Automate Button
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
- 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 | cellphone no | |
| kate | smith | [email protected] | 0123456776 |
| June | Jackson | [email protected] | 0891011126 |
| April | Fools | [email protected] | 0314151617 |
Thanks for the Help
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.
3 Replies
- audreygerred
Super User
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.
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.
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.
