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

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

I have 4 combo box and all 4 are from different table

 

Table 1: Asset

Table 2: Proof of identification

Table 3: Vehicle Type

Table 4: Visitor Type

 

All 4 tables i have sent in attachment

Highlighted
Community Support
Community Support

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

Hi @nagaraj007 ,

I notice that you not only use drop down, but also use combo box.

These are two different controls.

Could you tell me

1)the formula in 'Contact Person' combo box Items' property?

4)what is receiptPhoto? what is its data type? I need to figure out whether "First(receiptPhoto).Url" is text type.

Try this formula:

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

{
'Visitor Type': Dropdown1.SelectedText.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.SelectedText.Value,
'Asset Desc.': inpassetdessc.Text,
'Proof of Identification': Dropdown2_2.SelectedText.Value,
'Identification No.': inpidentification.Text,
'Vehicle Type': Dropdown2_3.SelectedText.Value,
'Vehicle No.': inpvehicle.Text,
'No. of Visitors': inpnoofvisitors.Text,
'Details of Accompaning Visitors': inpdetailsofacco.Text,
'Contact Person': ComboBox1.Selected.'Contact Person', 
'Contact Person Email': inpvehicle_1.Text,
Signature: PenInput1.Image, 
Checkin: Now(),
'Visitor Photo': First(receiptPhoto).Url
}
);
Navigate(
'Last Page',
None
)

Please notice that you need to use dropdown_name.SelectedText.Value to represent the Value that you select in drop down.

You need to use textinput_name.Text to represent the value intextinput.

You need to use combobox_name.Selected.fieldname to represent the value select in combo box.

What's more, make sure that you have primary key in your table, or else you can not update it in powerapps.

 

 

Best regards,

 

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

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

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

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