Hi @Giovanni1 ,
I did a test for you.
1\ This is my table in Sql server '[dbo].[Table_student]'.
2\ This is my stored procedure.
3\ Build an instant flow (1) and run(test) it.
Var1: Ask in powerapps
Var2: Ask in powerapps
View the run history and save the data structure.
[
{
"Id": 1,
"name": "Xiaoming",
"Sex": "hah!",
"Height": 180,
"Weight": 120,
"Chinese": 70,
"Math": 90,
"English": 65,
"TestDate": "2021-03-09T00:00:00"
}
]
4\ Rebuild the instant flow (2).
Body:
body('Execute_stored_procedure_(V2)').ResultSets.Table1
Paste the copied code into the red circle.
5\ Add a button contorl and set its onselect property to:
ClearCollect(Col,Test49.Run(1,1))
6\ The result is as follows:
In addition , hope this link will help you. Here
Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.
