Forum Discussion
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.
Seanan
Solution Supplier
Solution SupplierHi 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.
