Forum Discussion
File Name Power Automate Button Export
Hello, I'm exporting data to an Excel file using a Power Automate button in SharePoint. Is it possible to use a variable from a table 'Table'[Field] as the Excel file name? Thanks Stefan
7 Replies
Hi
Yes, it's possible — but Power Automate can’t directly read a DAX value like 'Table'[Field]. Instead, pass the value from Power BI using the Power Automate visual.
In your Power BI button, bind 'Table'[Field] to a field parameter sent to Power Automate. Then use triggerBody()?['FieldName'] inside the "File Name" input in your flow.
Make sure the field is included in the "Power BI button" trigger input.
freginier
How can i bind a 'Table'[Field] to a field parameter ?
To bind 'Table'[Field] to a field parameter in Power BI for use with a Power Automate button, follow these steps:
Add a table visual (or any visual) and make sure 'Table'[Field] is included.
Insert a Power Automate visual from the Visualizations pane.
Click on the Power Automate visual to open the Power Automate editor.
In the right panel, under Fields, drag 'Table'[Field] into the Power Automate data inputs section.
In the flow, use this field as a dynamic content — it will show up like Table_Field or similar under the trigger inputs.
Now the value from 'Table'[Field] will be passed to Power Automate when the button is clicked.
i cant find the table/field under Trigger?
Hi stefantaust,
Thank you for reaching out to the Microsoft Fabric Forum Community.
Can you please post this query in power automate forum, with below link to get the solution.
https://community.powerplatform.com/forums/thread/?groupid=46ce02a3-e1a7-4176-81fc-d93a4001d287
Kind regards,
Prasanna Kumar
