cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

The request operation is invalid. A value must be provided for item

Hello All,

 

I am using SQL on premises gateway.  When i submit form i get the attached error message. I have also pasted my code and i am not sure where the error is all about.

 

Patch(
'[dbo].[Registration]',Defaults('[dbo].[Registration]'),

{
'Visitor Type': Dropdown1,
'Visitor Name': INPVISITORNAME.Text,
'Company Name': inpcompanyname.Text,
'Purpose of Visit': inppurpose.Text,
'Mobile No': inpmobile.Text,
Email: inpemail.Text,
Designation: inpdesignation.Text,
City: inpcity.Text,
Asset: Dropdown2_4,
'Asset Desc.': inpassetdessc.Text,
'Proof of Identification': Dropdown2_2,
'Identification No.': inpidentification.Text,
'Vehicle Type': Dropdown2_3,
'Vehicle No.': inpvehicle.Text,
'No. of Visitors': inpnoofvisitors.Text,
'Details of Accompaning Visitors': inpdetailsofacco.Text,
'Contact Person': ComboBox1, 'Contact Person Email': inpvehicle_1,
Signature: PenInput1.Image, Checkin: Now(),
'Visitor Photo': First(receiptPhoto).Url
}
);
Navigate(
'Last Page',
None
)

 

SQL Table

 

[Visitor Name] varchar(50) Unchecked
[Company Name] varchar(250) Checked
[Purpose of Visit] varchar(250) Checked
[Mobile No] nchar(10) Checked
[Contact Person] varchar(50) Unchecked
[Visitor Type] varchar(50) Checked
Email varchar(50) Checked
Designation varchar(50) Checked
City varchar(50) Checked
Asset varchar(50) Checked
[Asset Desc.] varchar(50) Checked
[Proof of Identification] varchar(50) Unchecked
[Identification No.] varchar(50) Unchecked
[Vehicle Type] varchar(50) Checked
[Vehicle No.] varchar(50) Checked
[No. of Visitors] nchar(10) Checked
[Details of Accompaning Visitors] varchar(250) Checked
[Visitor Photo] varchar(500) Checked
Signature varchar(250) Checked
Checkin smalldatetime Checked
Checkout smalldatetime Checked
[Contact Person Email] varchar(50) Unchecked
ID int Unchecked
Unchecked

11 REPLIES 11
Highlighted
Helper V
Helper V

Re: The request operation is invalid. A value must be provided for item

Attached form, i will get the error once i add the data and save it.

Highlighted
Super User III
Super User III

Re: The request operation is invalid. A value must be provided for item

Try this:
Change all the dropdown and Combobox to:
    Dropdown.Selected.Value and Combobox.Selected.Value 

 

Patch(
'[dbo].[Registration]',Defaults('[dbo].[Registration]'),

{
'Visitor Type': Dropdown1.Selected.Value,
'Visitor Name': INPVISITORNAME.Text,
'Company Name': inpcompanyname.Text,
'Purpose of Visit': inppurpose.Text,
'Mobile No': inpmobile.Text,
Email: inpemail.Text,
Designation: inpdesignation.Text,
City: inpcity.Text,
Asset: Dropdown2_4.Selected.Value,
'Asset Desc.': inpassetdessc.Text,
'Proof of Identification': Dropdown2_2.Selected.Value,
'Identification No.': inpidentification.Text,
'Vehicle Type': Dropdown2_3.Selected.Value,
'Vehicle No.': inpvehicle.Text,
'No. of Visitors': inpnoofvisitors.Text,
'Details of Accompaning Visitors': inpdetailsofacco.Text,
'Contact Person': ComboBox1.Selected.Value, 'Contact Person Email': inpvehicle_1,
Signature: PenInput1.Image, Checkin: Now(),
'Visitor Photo': First(receiptPhoto).Url
}
);
Navigate(
'Last Page',
None
)

Highlighted
Helper V
Helper V

Re: The request operation is invalid. A value must be provided for item

Hi,

Now i am getting error different error. Attached is the document.

Highlighted
Super User III
Super User III

Re: The request operation is invalid. A value must be provided for item

Change the Asset Dropdown.Selected.Value to: Dropdown.SelectedText.Value

Highlighted
Helper V
Helper V

Re: The request operation is invalid. A value must be provided for item

Hi,

I am getting it for all combo box error. Now the error is attached

 

 
Highlighted
Super User III
Super User III

Re: The request operation is invalid. A value must be provided for item

Try this:
'Contact Person Email': inpvehicle_1.Text

Highlighted
Helper V
Helper V

Re: The request operation is invalid. A value must be provided for item

Hi ,

 

All combo box is giving one or the other error. Please advice.

 

Highlighted
Helper V
Helper V

Re: The request operation is invalid. A value must be provided for item

Please help me in regards to this. I am unable to figure it out where the problem is 

Highlighted
Super User III
Super User III

Re: The request operation is invalid. A value must be provided for item

What are the items on the combobox.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (5,608)