我已经在Power Apps中制作了以下屏幕：
我的目标很简单：我希望最终用户能够将数据输入到这些文本框中 - ＆gt;用户单击“确定”按钮 - ＆gt;在带有列的关系数据表中，下面的用户保存了数据；名称，数量和度量。
完成所有数据条目后，“保存”按钮应以JSON格式发送完整的数据表作为SQL Server存储过程的输入，该过程接受参数@json。这是如何完成的？
我尝试的：尝试制作画廊，数据表，表单等。但是所有这些都要求我连接到现有数据集。相反，我希望用户创建数据集，然后然后将数据发送到SQL Server数据库。
I have made the following screen in Power Apps:
My goal is simple: I wish the end-user to enter data into these text boxes -> User clicks "OK" button -> Data is saved for the user right below in a relational data table with columns; Name, Amount, and Measure.
Once all data entries are made, a "Save" button should send the complete data table in JSON format as input for a SQL Server stored procedure, which accepts the parameter @json. How is this accomplished?
What I tried: Tried making a gallery, data table, form, etc. But all of these require me to connect to an existing data set. I instead want the user to create the data set, and then have the data sent to a SQL Server database.
发布评论
评论（1）
使用
作为替代方案，如果您真正想使用存储过程，请将Power Automate连接到PowerApp并从那里运行存储过程。不过，这引入了依赖性。您的电话。
>当心：，
Use the built-in SQL Connector
As an alternative, if you realllly want to use a Stored Procedure, connect Power Automate to your PowerApp and run the Stored Procedure from there. This introduces dependencies though. Your call. Example
Beware: