You’re offline. This is a read only version of the page.
Announcements
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.
@Anonymous
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:
---
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."
Share
Report
All responses (
Answers (
29,989
