cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dpegs22
Helper I
Helper I

Save Error

I am creating a PowerApp where an end-user enters the following for an employee:

Name, Date, Non-Production Time (in Hours), and Comments. 

 

This information then populates into a SQL table entitled ProceduresTeamReporting after the end-user presses Save

 

When I run this PowerApp, here is the error that I get when I hover my mouse over the code :

The requested operation is invalid. Server Response: ProceduresTeamReporting failed. A value must be provided for item. clientrequestid: 236fod78-eac4-47a3-9dad-ae1650d41b13

 

I have attached a screen shot of my code as seen below.

 

Dpegs22_0-1651150174807.png

 

Any idea on what I am doing wrong?

7 REPLIES 7
Silvester
Skilled Sharer
Skilled Sharer

Can you confirm if the table in SQL is well connected to your app?

Yes, the table is connected to the PowerApp.  Here are the fields. I do not have an ID field in my PowerApp yet.

Dpegs22_0-1651151002250.png

 

Dpegs22_1-1651151182093.png

 

Dpegs22_2-1651151216395.png

 

Silvester
Skilled Sharer
Skilled Sharer

Seen. I am sure the ID field need to be populated as well. It is required from the datasource i presume.

Dpegs22
Helper I
Helper I

I put the ID field into the PowerApp, and this is the message that I am getting:
'ID: The specified column is generated by the server and can't be specified'. 

The ID column is supposed to automatically generate a number in the sql table.

Here is my new code.

 

Dpegs22_0-1651171079638.png

 

 

Silvester
Skilled Sharer
Skilled Sharer

The ID is basically a GUID. Understood. One work around this is to use a load a form that you connect to the datasource, and you use a SubmitFrom function to send the data. It will help you avoid the issu here. It also automatically generate the GUID from the SQL interface. 


If this find this post interesting, do you mind giving it a  thumbs up?

Dpegs22
Helper I
Helper I

I changed to a form. Anyway, I switched the Name textbox to a Name combox, and I am getting this error. 'Expected Text value'. Any idea why?

Silvester
Skilled Sharer
Skilled Sharer

Yes, so you need to convert the value of the combo box to text for it to work.
Text(ComboBox1.Selected.Name) for example.

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (2,657)