cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
johnmarlowe
Level: Powered On

Returning and array to Powerapps using the Response Method

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:

https://powerapps.microsoft.com/en-us/blog/return-an-array-from-flow-to-powerapps-response-method/

 

 

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: 

 

 
ActionResponseSkipped. The execution of template action 'Response' is skipped: the client application is not waiting for a response from service

 

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.

 

Thanks

Andrew

6 REPLIES 6
Lisabel0
Level 8

Re: Returning and array to Powerapps using the Response Method

I suggest that you could open a ticked in https://powerapps.microsoft.com/en-us/support/pro/ticket/

WPB
Level 8

Re: Returning and array to Powerapps using the Response Method

@v-xida-msft

 

I got the exact same problem and can't use your support link. 'Canada'

 

Other related posts: #1, #2

 

#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.

 

[
  {
    "ID"1,
    "Biogaz"2,
    "PavageCouvercle"true,
    "AccEauChambre"1,
    "FondChambre"true,
    "BouchonValve"true,
    "ValveMesure"true,
    "TubeMesure"true,
    "Actuateur"true,
    "Isolant"true,
    "ConnexConduite"true,
    "CableChauf"true,
    "TfondPuits"9,
    "Tcable"8,
    "Tactuateur"7,
    "TubeExtraction"true,
    "ProfHPF"6,
    "ProfEau"5,
    "Commentaire""Commentaire",
    "CreatedBy"3,
    "CreationDate""2018-09-19T00:00:00",
    "ModifiedBy"4,
    "ModifiedDate""2018-09-19T00:00:00",
    "Puits_ID"4
  },...
]

I'm using 

ClearCollect(Array,TestFlow.Run())

And all i get is 'True'. This used to work, what changed?

WPB
Level 8

Re: Returning and array to Powerapps using the Response Method

Still doesn't work...

Tried with another connection too.

doubles
Level: Powered On

Re: Returning and array to Powerapps using the Response Method

I currently get the correct field names in the collection, but no data (even though when testing the flow, I get the correct data in the output).

Dawidvh
Level 10

Re: Returning and array to Powerapps using the Response Method

Hi everyone,

 

Below are two videos dealing with advanced queries to SQL from PowerApps (using Flow).
For SQL Azure you can use direct (native) queries:
https://youtu.be/DII10gK715I

 

For on-premesis SQL servers, native queries are not supported from Flow (you will get an error: operation Execute Native Sql is currently not supported using an on-prem gateway connection), so we have to use stored procedures to accomplish the same:
https://youtu.be/BAGBzI4zdww

 

Please let me know if you don't come right.

 

Dawid van Heerden
Follow on Twitter: @davestechtips
Subscribe to YouTube: https://www.youtube.com/davestechtips?sub_confirmation=1
**If you found this reply helpful, please mark this as the answer to close the topic and make it easier to find for other people with similar questions.

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Kudoed Authors
Users Online
Currently online: 276 members 5,246 guests
Please welcome our newest community members: