Hi - I wonder if anyone can help me. I'm just trying out the suggested method for returning an array into Powerapps, and I appear to have a slight issue. Link for blog article:
Firstly, I have adapted the method to replace the "Execute a SQL Query" action wtih a "Execute SQL Stored Procedure" action as the the former action wasn't allowed using a gateway to an on prem DB. However I believed I had all but succeed in this as when I tested the flow (consisting of a Powerapps Trigger; an Execute SQL Stored Procedure; and a Reponse).
I set up the Body formula as advised (body('execProc').ResultSets.Table1) and set the Schema from the results of the stored procedure. When I tested this the first time the flow executed successfully, the Stored Proc returned an array of data and the output section of the 'Response' Action had a body containing the array in JSON format. When I continued with the method using the ClearCollect(searchResults, execProcFlow.Run()), I noticed that the collection returned was just the value "True". When I fiddled about a bit an tried rebuilding the flow I've noticed that he first time the flow runs after being set up it works as expected, however on all subsequent executions (which show as succesful) they have not Output section in the Response Action and have the message:
I'm assuming that this is why the response fed into Powerapps is merely "True". Does anyone know what the above message is indicating is wrong and why this might work on the initial execution but not on subsequent executions.
I suggest that you could open a ticked in https://powerapps.microsoft.com/en-us/support/pro/ticket/
I got the exact same problem and can't use your support link. 'Canada'
#1 has a good desciption of the issue and for some reason, said it was solved.
This is the OUTPUTS of my Response tile in Flow.
And all i get is 'True'. This used to work, what changed?
Still not fixed I suppose.