Answered

PowerApps to SQL Server Form

(1) Share

Report

Posted on by jlmiller35 Microsoft Employee

I've created a PowerApps form to add a row to a table in a SQL Server database. The form mode is set to "New". Here is the UsbmitForm statement: SubmitForm(FORMTargetTable);Refresh('[dbo].[TargetTable]');ResetForm(FORMTargetTable).

There are seven data cards (each for a required field in the target table) with associated controls. Five controls use dropdown lists to limit data entered. Lists are sourced from other tables within the SQL Server database. The structure for each data card is DataCard1.Update.Field1.TargetTable from DropownX.FieldX.SourceTable.

Update statements for each data card with a dropdown are: DropdownX.Selected.FieldX. An earlier version had the update parameter set to [dbo].[TargetTable].[Field1].

The SubmitForm statement for the button control is: SubmitForm(FORMName);Refresh('[dbo].[TargetTable]');ResetForm(FORMName)

When I click the button to submit the form, I get an error message that the data card associated with the first dropdown list has no data despite having made a selection. My guess is if this data card is fixed, the next in line will have the same issue. I suspect dropdown selection aren't being passed through the update parameter of the data card.

Any suggestions for how to overcome this? I've looked at Patch but don't think it should be needed for this app as this is a one screen app pushing data to a single table in SQL Server.

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

jlmiller35 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

One correction to SubmitForm, instead of it saying FORMTargetTable it should say FORMForm1.

Was this reply helpful? Yes No
Verified answer

jlmiller35 Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Thanks for the response. Since posting the original question, I found my mistake in first building the form.

On the data cards with the dropdown lists, I had removed the Data Value controls. Removing those cards and placing new ones, I added the dropdowns and set the update parameter for the data card to: DropdownName.Selected.DropdownDataElementName.

This change passed the dropdown selection to the data value which is what SubmitForm picks up. Now, once selections are made and all required fields completed, clicking the button to accept adds a new record to the SQL Server database.

Now if I can only recreate the app for online use with a direct query to the database. But that's another topic.

Was this reply helpful? Yes No