cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

SQL stored procedure return value

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper II
Helper II

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!

View solution in original post

1 REPLY 1
Highlighted
Helper II
Helper II

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!

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (11,870)