cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

PowerApp Runs FLOW but NO COLLECITON, flow has data but PowerApp never gets it!

The Flow is based on a working PowerApp, were it recieves and email address from the Power app

then calls a Stored Procedure and then Respods.

I test the Flow, and even Hard Code an Email address in the flow, and the RESPONSE OUTPUT is there, 

 

I try creating a new PowerApp to test, where i use a button to TRIGGER the FLOW, and then place into the Gallary.

The PowerApp Runs, no errors or warnings.  But the Gallary does not populate and the Colleciotn is EMPTY,

but does have the COLUMN Names.

 

How can I test or figure out where the issue is?  I seem to have hit a wall.  

 

I thought I would try and elimnate the Paramter input (ie Hard code an Email)

and that works fine, pulls the data for the email into the OUTPUT of the RESPONSE in the flow.

I created a NEW Power App, put a button and a Gallary, and did the CLEARCOLLECT call

.

IT seems to trigger fine, and the Flow History shows it ran, and has Data.

 

But the POWER APP never displays the data, and Never has a Collection.

Buttuon code is ClearCollect(queryResults,DOT_EMPLOYEE_LOOKUP.Run("All"))

 

WHAT or HOW can I find out what is going on, the PowerApp does trigger the Flow,

the flow has Data 

{
  "Table1": [
    {
      "EMPL_ID""0370775",
      "EmployeeName""TIGER, BILLY G (B037077)",
      "ExemptStatus""S",
      "JobTitle""SIGNAL MAINTAINER (BRS)       ",
      "EmployeeEmail""BILLY.TIGER@BNSF.COM",
      "Location""Heartland",
      "WorkGroup""Signals"
    }
  ]
}

 

but No Collection or display in the gallery ever occurs!

HELP!

 

 

 

2 REPLIES 2
Frequent Visitor

Ok, not sure if its a Browser thing (Chrome vs IE, etc)

 

but in the RESPONSE, if you are calling a STORED PROCEDURE, you have the use the 


ResultSets.Table1    not just ResultSets 

 

when I created the 1st App, it was under IE and I am not sure why, but I was PRESENTED

the ResultsSet.Table1  in the options when you select the BODY in the RESPONSE.

 

This time I was in CHROME, as I am Now at home because of the Virus, and IE won't authenticate here.

 

So I had to use the TRICK of putting in an EXPRESSION of the body('name of Stored procedure step').ResultSets.Table1

 

Once I did that, all worked fine.  So even though my OUTPUT was populating in RESPONSE with the ResutSets,

I assume the format of the JSON was not correct as it was not a TABLE.

 

Either way, not sure why Sometime the options comes up or not, but you can FORCE it by using the EXPRESSION

to just put in the Table1  

 

CRAZY, was pulling my hair out and that was it.

 

Hi,

 

Thanks for your update. I am glad that you were able to figure out your issue that you were having. It is definitely odd that this was only occurring across certain browsers. I just wanted to add a bit more information on this. Feel free to take a look.

 

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-set

 

Regards,

 

Alex

 

-------

 

Community Support Team _ Alex Rezac
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (101,800)