Hi Team,
Currently I am building an PowerApps, where based on user selection values from a couple of combo boxes, I am creating a SQL Query , which i then store to a variable and pass it to a flow, which runs the query in a "Execute SQL Query" module and returns back the output using the Response module. Please find below the flow :
I then the store the response in a collection and then display it using Data table. This was working fine , till I had fixed set of columns.
Now based on the user selection input , the query will keep changing and so will be the output columns to be displayed. So the response section where we define our columns, will need to be to changed every time and also in Data table in power apps, we have manually select the columns to be displayed , that will need to changed every time based on the resulting columns.
Can anyone share any tips, as to how can this process by done dynamically ?
Can galleries be used ? if so do we need to change the source of the gallery every time ? how can that be done dynamically ?
Thanks again
Solved! Go to Solution.
Hi @pradeepjain ,
The response action only supports fixed data structures.
Best Regards,
Bof
Hi @pradeepjain ,
The response action only supports fixed data structures.
Best Regards,
Bof
Thanks for the info