Save data entries to empty data table in PowerApps, and save in SQL Server afterwards

(0) Share

Report

Posted on by msuser48

I have made the following screen in Power Apps:

Power apps canvas

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/submitted to a SQL Server database stored procedure.

Thanks!

Categories:

Building Power Apps

All responses (1)

Answers (1)

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @msuser48,

Do you want to save the input data to a collection?

Could you please share a bit more about your scenario?

I suggest you use a Gallery.

Here are steps to achieve your need:

1). Set the OK button OnSelect as below to dynamic add new records to a collection:

Collect(colTable,{Name:Name_TextInput.Text,Amount:Amount_TextInput.Text,Measure:Measure_TextInput.Text})

2). Set the Gallery Items property as the colTable to display all the input data

3). Set the Save button OnSelect as below to send the complete data in JSON format:

Set(JsonDate,JSON(colTable))