Forum Discussion

stefantaust's avatar
stefantaust
Helper I
1 year ago

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    
Need Help
stefantaust's avatar
stefantaust
Helper I
1 year ago

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

  • freginier's avatar
    freginier
    Solution Sage
    1 year ago

    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's avatar
      stefantaust
      Helper I
      1 year ago

      i cant find the table/field under Trigger?

       

      • freginier's avatar
        freginier
        Solution Sage
        1 year ago

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