Power Platform Community Forum Thread Details

Hi,

I'm stuck with the following. I had issues with accessing my SQL data from PowerApps due to using non delegable functions. I have seen a workaround is to create a stored procs in SQL and then to use PowerAutomate to load the data into a collection, allowing me to use the collection with more than 2000+ records.

I have created a stored procs in SQL using

I go to PowerAutomate

Create new flow from within PowerApps and the Flow tab

Select PowerApps as the trigger, give it a name

* Select action, Execute Stored Procedure (V2) - select server, DB and Procedure name

I add in a 'Response' action and in the body I select 'body' from the execute stored procedure (v2)

I click save and I run a manual test of the flow, copy the schema generated by the test and paste in 'generate from sample' save my flow and no errors

I add the flow to my app

I attempt to create a collection using the data flow will bring back but the collection is empty:

ClearCollect(ColSQLView, SQLView.Run())

I only have 2 additional options to add 'properties' and 'type', and when I navigate to my collection its empty with only 2 headings properties and type, I dont even know what these are... I was expecting my columns from SQL to be here

Categories:

Building Power Apps