File Name Power Automate Button Export

[stefantaust]

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

[v-pgoloju]

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

[stefantaust]

How can i bind a 'Table'[Field] to a field parameter ?

[freginier]

To bind 'Table'[Field] to a field parameter in Power BI for use with a Power Automate button, follow these steps:

1. Add a table visual (or any visual) and make sure 'Table'[Field] is included.

2. Insert a Power Automate visual from the Visualizations pane.

3. Click on the Power Automate visual to open the Power Automate editor.

4. In the right panel, under Fields, drag 'Table'[Field] into the Power Automate data inputs section.

5. 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.

[stefantaust]

i cant find the table/field under Trigger?

[freginier]

You won’t see the table/field directly in the trigger step. First, you must add the field to the Power Automate visual in Power BI Desktop under the "Fields" section.

Once that's done:

1. Go back to Power Automate.

2. Click on the Power BI trigger (“Klick auf Power BI-Schaltfläche”).

3. You’ll now see the fields passed from Power BI appear as dynamic content (like Table_FieldName) in later steps.

If fields don’t show, double-check that the visual in Power BI includes them before clicking “Create new flow.”

[stefantaust]

Hello, I've tried it now, but I just can't seem to solve my problem. I know I have to load the "Materialnummer_Gesamt" field into PowerAutomate first, but I can't.

I got my Flow from the YouTube tutorial
Youtube  

I would like to add a field from a table to PowerAutomate in my current flow, and I can use it as the file name.
Thanks, Stefan

[freginier]

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