I'm using the ServiceNow connector to query a table and return results to a PowerApp. The PowerApp triggers the flow:
Which is producing the correct results:
Yet no data is appearing in the PowerApp save for the fields appearing in the layout customization drop menus:
Triggering the flow for reference:
Has anyone encountered this issue?
Solved! Go to Solution.
Solved it! In the instructional video Brian Dang specifies that for his SQL query one needs the results.table1. For the PowerApps connector for the dynamic content you can put List Record Body or List Record Result. Result is the ticket, and I had mistakenly been returning the body.
I should note that I'm referencing this guide: https://powerapps.microsoft.com/en-us/blog/return-an-array-from-flow-to-powerapps-response-method/
Solved it! In the instructional video Brian Dang specifies that for his SQL query one needs the results.table1. For the PowerApps connector for the dynamic content you can put List Record Body or List Record Result. Result is the ticket, and I had mistakenly been returning the body.
User | Count |
---|---|
139 | |
129 | |
75 | |
74 | |
69 |
User | Count |
---|---|
221 | |
135 | |
78 | |
58 | |
56 |