Unanswered

Power automate response from sql to power apps table

(1) Share

Report

Posted on by shaidar

Hi,

I'm trying to bring data from a SQL stored proc into power apps- i started with a power automate flow that ends in a response action and the data has following format :

In power apps i added a button on on click :

ClearCollect(temptable,stored_proc_to_data.Run(1))

(the stored proc takes company_id as a parameter and filters for it)

However in my collections my temptable looks like this with empty rows:

I will eventually need to add many more columns i just reduced it to 4 to try and trouble shoot. I searched around and someone suggested to enable 'Explicit column selection' but that didnt help.

I also tried making the input for the response actions

body('Execute_stored_procedure_(V2)')?['resultsets']?['Table1']

but that gave this error in power apps

Would appreciate any leads on a fix!

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

ANB 7,223 Super User 2025 Season 2 on at

Like (1)

Report
Hi @shaidar Do this:

Remove the response action from your flow.

Save the Flow and test the flow manually.

You will get the output from Store Procedure.

Copy the output as it and then add Response action to your flow.

Then click on Generate from Sample

Paste the exact output from SP to generate proper scheme.

Basically, as per the error it is showing that you have created a scheme with just an array, however it is expecting object.

Save the flow and refresh the flow in app and try again.

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No
mmbr1606 14,605 Super User 2025 Season 2 on at

Like (1)

Report

hey @shaidar

i think your topic would be a better fit for the power automate communit forum to be found here:

Microsoft Power Automate Community - Power Platform Community

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
shaidar 16 on at

Like (1)

Report

Thank you - but now its giving me this

how do i tell it to get whats in the body

Was this reply helpful? Yes No
ANB 7,223 Super User 2025 Season 2 on at

Like (1)

Report

@shaidar Please follow these:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Display-results-from-Flow-SQL-Stored-Procedure-in-my-PowerApp/td-p/366593

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

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No