Unanswered

PowerApps

(0) Share

Report

Posted on by Zorkito1

Hello, I have a question.

I migrated from dataverse to SQL due to row limits present in Power Apps. I changed all the names of the tables and I'm sure that PowerApps can get the information from the Database, but the problem is that when I try to save something in the form, this error appears: "The 'registerserviceID' field is required" , this field is a primary key so ,for me , it doesn't even make sense. I'm new in PowerApps bindings to SQL, but I'm not new in SQL.

Thanks for your time!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

rbrooks66 143 on at

Like (1)

Report
Copy link

Link copied!

I created an input form and used SQL because I wanted all the drop downs to point to different reference tables. I used a Stored Procedure to save the data to SQL. Are you using a Stored Procedure or did you find another way to save the data? Does your registerserviceID field exist only in the SQL table? Is it an identity or a guid type? Just trying to figure out how you set it up.

Was this reply helpful? Yes No
Zorkito1 3 on at

Like (0)

Report
Copy link

Link copied!

Hello Again,

The way I'm saving the data is by sending the EditForm in question.
registerserviceID only exists in the SQL table and is not being used or called in powerapps. What do you mean by "Stored Procedure"?(i know the meaning of "Stored Procedure") I created a database from code and inserted it into Microsoft Azure. The question is, why does this error appear?

Was this reply helpful? Yes No
rbrooks66 143 on at

Like (0)

Report
Copy link

Link copied!

Let me go through the process I did after addressing what I think could be wrong with your issue. The registererviceID only exists in the SQL table but how are you supplying that value? When you go to insert the record the table still needs the primary key. Do you have it set up as an identity column where the system automatically increments the primary key? If not, whether you declared the primary key as a GUID or integer or whatever, you still need to supply it. This is my table, and I have the primary key set up as an identity field, so I don't need to supply the primary key, it will automatically increment the key by 1 when the record is inserted. If that fixes your problem, don't worry about the rest of this post. But, I will explain what I did to get the data from my form to my SQL table.

Then, I used a stored procedure to connect to the SQL table. In SQL I have a stored procedure to insert the record from Power Apps. This link explains how to set this up https://www.mssqltips.com/sqlservertip/6857/call-sql-server-stored-procedure-from-power-apps/. This is the stored procedure, with an input for each field in my power apps form (Location, Category, SubCategory, etc.).

This is my power apps form.
I hooked the stored procedure to my power apps form as described in the link above to my Save button.

Hope this helps, good luck.

Was this reply helpful? Yes No