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

[bhall2881]

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. 

[Seanan]

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.

[bhall2881]

[Seanan]

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.