Sending data to SQL Server Using Stored Procedure

[omi18]

Hello,

I have the button OnSelect property set to run the following flow. 

SetFinal.Run(Gallery1.Selected.ID,TextInput1.Text,DayLoad.Value,Overload.Value,Student.Value,New.Value,From.Value,Approval.Value,Hold.Value,Eligible.Value,Account.Selected.Result,Center.Selected.Result,User().FullName)

I'm getting no error on both Powerapps and Automate side. But when I check in the database is shows nothing is updated. 

Any suggestions?

Thanks,

Omi

[RandyHayes · Accepted solution]

@omi18 

Take a look at the Flow run history and look at the information being passed to your SP.  You should be able to identify if the proper information is being passed to it.  If so, then I would look at your SP to see where the problem might be.

I hope this is helpful for you.

[omi18]

Hi @RandyHayes ,

Right actually there is an error from the database side.

Thanks,

Omi

[RandyHayes]

@omi18 

There's where the problem is!

[omi18]

Hi @RandyHayes ,

It is working now. was a small mistake.

Thanks,

Omi