I have been struggling with getting something to work in Power Automate. I have a flow that pulls rows from a table and in the row one of the columns contains a sql query, usually just a select with a where clause. I throw the sql query into a variable and execute it with the execute SQL step. The problem comes in , in that I need to iterate over the rows that are returned and somehow iterate over each column which is not fixed so i cannot use the column name. I need to add the data either to an array or a table of some sort and then after iteration include the output into the body of a chat message as either text table or perhaps an attachment. Every method I have tried ether from search or from chatgtp is not working, help please.
