Pass variables from PowerApps to a stored procedure based what the user has selected

[smntsantsa]

Hi ,

I need help with the below scenario, if anyone is able to assist I would appreciate it :

Scenario:

Execute a stored procedure in PowerApps via a button click. The stored proc works fine when I test it manually however I want to pass parameters to it based on what the user has selected. To achieve this I have used text boxes and check boxes as the input source. The aim is to be able to select multiple rows and click a button (run SP) to approve those selected records.

The drawback of using text boxes is that they are editable at run time and have not found a way to lock them. Is it possible to make them read only text boxes?

I have also tried using a data table in place of text boxes however I couldn’t find a way to select an individual record at a time and pass those fields as parameters to the stored procedure. 

Thanks in advance.

[mdevaney · Accepted solution]

@smntsantsa 

Have you seen this forum post about passing variables to stored procedures?  It looks like this is achievable using MS Automate.

Link To Relevant Forum Post:

https://powerusers.microsoft.com/t5/Building-Power-Apps-Formerly/How-to-pass-parameters-to-Stored-Pr...

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."