GitHub

sql-array-functions.md

ARRAY[expr1, expr2, ...] Constructs a SQL ARRAY literal from the provided expression arguments. All arguments must be of the same type. ARRAY_APPEND(arr, expr) Appends the expression to the array. The ...
Microsoft

Return an array from a SQL Stored Procedure to PowerApps (Split Method)

Author’s note: this blog has been updated with a link to the Request – Response method. Users who want to execute a SQL stored procedure in Flow can now send its resulting array into PowerApps. The ...
GitHub

yoavfeld/sql-to-json

This object is a generic tool to convert your sql tables to an any structured json object. the object gets a connected db client and a structure json object that describes the sql tables and the ...
Microsoft

Return an Array from Flow to PowerApps (Response Method)

Update 2018-06-06: Please not that in the step involving reviewing the schema for the Response step, be sure to check that each column’s type is specified as string, integer, boolean, etc. or the flow ...