Announcements
Hey All,
I have an issue with my app. I have a Combo Box connected to an excel table. The values are correct and I can search for the particular asset record I'm looking for. The problem is when I submit the form it says item already created in the server...
I guess what I need is.
The combobox purely there to select the particular asset then the user updates the other two fields by text input and thus creating a record In my table.
Please Help!
If you intend to update the existing record, have you made sure the form is in Edit mode?
Hi, When the form is in edit, it cannot be viewed when i play app?
@Woody2312 wrote: Hi, When the form is in edit, it cannot be viewed when i play app?
This means the Item property of the form doesn't have a reference to the record you're trying to edit. This is often a LookUp() on the table containing the record you're trying to edit. If you share information about your table and the field you use to uniquely identify the record, we can help you build the LookUp().
Bryan
Hi Bryan, thanks for the response,
I have this Table below and the unique identifier is Trailer ID
There is over a 1000 records in there and i want the combobox to be searchable so users cannot select the wrong asset.
appreciate the help 🙂
OK, make sure your combobox is set to allow searching, but multiple selections is turned off. The Items property should be set to the TrailerID1 and make sure the Trailer ID is listed under the defined Fields.
Now, for your form, put the following in the Item property: LookUp(TrailerID1, 'Trailer ID' = comboboxName.Selected.'Trailer ID')
Hi Bryan,
I am getting the below error, sorry not sure if i have made a mistake...
Just for Clarity, I have tried that formula in the Form3 Item Property and the ComboBox separately.
Regards
It's a bit confusing with all of these properties with similar names, so I'll re-phrase:
Form3 Items: TrailerID1
Form3 Item: LookUp(TrailerID1, 'Trailer ID' = comboboxName.Selected.'Trailer ID')
ComboBox2 Items: TrailerID1, with the Fields to include 'Trailer ID'
When you're re-typing this into your app, make use of the Intellisense autocompletion feature as you type, which helps Power Apps connect everything properly in behind.
I am now getting this error.... definitely User Error on my behalf...
I have put screenshot of Form 3 Items and combobox Item
really sorry, I am very new to power apps
Hey, we all start somewhere, and I learn lots from this community too 🙂
That error is a good thing - you've connected the table to the form and combobox correctly - it is showing an error because there is nothing valid to lookup when there is no choice in the combobox. So, let's modify that Item code in the form code a touch:
If(!IsBlank(ComboBox2.Selected), LookUp(TrailerID1, 'Trailer ID' = ComboBox2.Selected.'Trailer ID'))
Two more things:
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 342 Most Valuable Professional
11manish 234
Valantis 187
