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.
Any idea on what I am doing wrong?
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.
Seen. I am sure the ID field need to be populated as well. It is required from the datasource i presume.
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.
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?
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?
Yes, so you need to convert the value of the combo box to text for it to work.
Text(ComboBox1.Selected.Name) for example.
User | Count |
---|---|
162 | |
95 | |
77 | |
72 | |
58 |
User | Count |
---|---|
216 | |
166 | |
97 | |
96 | |
74 |