Hi everyone
I have an SQL stored procedure that returns a value. What I get in powerapps when I call the procedure using Flow is a table with one column that has the return value I need.
Is there a way for the return table to be returned as a value that I could directly assign to a variable inside PowerApps?
Your help is appreciated as always. 🙂
Cheers!
Solved! Go to Solution.
Just sharing solution
//Stores the table in a collection
ClearCollect(collAssetIDCount,getTop1AssetID.Run());
//Assigns the value to a variable (AssetIDCount)
Set(AssetIDCount,First(collAssetIDCount).Column1)
I wish I could directly fetch a value to assign to a variable but this worked. 🙂
Cheers!
Just sharing solution
//Stores the table in a collection
ClearCollect(collAssetIDCount,getTop1AssetID.Run());
//Assigns the value to a variable (AssetIDCount)
Set(AssetIDCount,First(collAssetIDCount).Column1)
I wish I could directly fetch a value to assign to a variable but this worked. 🙂
Cheers!
User | Count |
---|---|
252 | |
102 | |
94 | |
50 | |
37 |