SQL stored procedure return value

[JomarGF]

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!

[JomarGF · Accepted 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!