Forum Discussion

bhall2881's avatar
bhall2881
New Member
4 years ago

How can I get just the Value From a Query (Done in Power Automate via query against a dataset) HELP!

In power Automate I am trying to Query Power Bi. I get a result, but I only need the value and not the other information. 

 

3 Replies

  • Seanan's avatar
    Seanan
    Icon for Solution Supplier rankSolution Supplier
    4 years ago

    Hi bhall2881 

    You can use that value in an apply to each connector and inside of the apply to each loop use the "add a row into a table" connector to append your value into the excel table.

    If the add a row into a table connector does not work insantly you may need to get the excel file first. Check out the list of excel connectors here 

    For future reference this question would be better suited in the Power Automate forumns found here.

      • Seanan's avatar
        Seanan
        Icon for Solution Supplier rankSolution Supplier
        4 years ago

        Hi bhall2881 

        Unfortunately, my power automate knowledge is relatively limited and therefore I'm not really sure what to suggest from here. You would be better off posting this issue in the Power Automate Forums as I'm super someone there would have the solution to your issue.