You’re offline. This is a read only version of the page.
115
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!
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!
Share
Report
All responses (
Answers (
