I am able to run my sql query and, can confirm its bringing results back. But, when I go to 'Response' step 'Result set' variable is not present in the 'dynamic content' list.
Is this a bug on sql connector? or I am missing something?
Solved! Go to Solution.
Hi @Anonymous ,
Please check this blog and see if it helps:
https://powerapps.microsoft.com/en-us/blog/return-an-array-from-flow-to-powerapps-response-method/
You could use Parse JSON action to parse the body of the Execute a SQL query(V2) action.
Then you could search the Dynamic content in search box according to the property name.
Best Regards,
This is how I can confirm I am getting results back.
Hi @Anonymous ,
Please check this blog and see if it helps:
https://powerapps.microsoft.com/en-us/blog/return-an-array-from-flow-to-powerapps-response-method/
You could use Parse JSON action to parse the body of the Execute a SQL query(V2) action.
Then you could search the Dynamic content in search box according to the property name.
Best Regards,
User | Count |
---|---|
6 | |
6 | |
4 | |
3 | |
2 |
User | Count |
---|---|
8 | |
7 | |
4 | |
4 | |
4 |