Answered

EditForm Message "Field is required" even though ComboBox has item selected

(0) Share

Report

Posted on by AlexW8

Hello all, I have a problem I need some help with. I am a programmer by trade (c#, VB .NET) but am new to PowerApps. I have developed a canvas app that uses a SharePoint List as its data source. This list is put into a collection, which is set as the source for the Browse Gallery. Things get a little tricky when I get to the Edit Form. I have one column in the List called Job which is a LookUp (Choice?) column referencing another List of Jobs on the same SharePoint site. I need the ComboBox to show 2 columns: the Job Number and Job Description. The Job Number column is the 'Title' column, now renamed to 'Job #'; I know this is bad but I can't start over with a new column. The Job Description Column is called 'Project #' or 'Project_x0020__x0023_'. Getting the ComboBox to show BOTH columns is difficult or impossible with a LookUp column (it only shows the "Value" and "ID" Fields) so I decided to set up a new collection with the contents of the Job List and set that as my data source for the ComboBox. Once this is set I can set my DisplayFields and SearchFields, and the ComboBox shows both the Job Number and Job Description fields, exactly like I want. I am able to set the DefaultSelectedItems for the ComboBox to "Parent.Default". Since the ComboBox is inside a DataCard, the value for ThisItem.Job appears to get selected by default. If I am creating a new item, or editing an existing item but I change the Job Number, everything works fine. The selection gets pushed up to the SharePoint List, everything works fine.

Everything above this paragraph works as expected, however I have found one scenario that does not work. If I try to edit an existing record, but do not click on the Job ComboBox, I get the error message: "Job is required" even though the ComboBox has the correct Job Number from the SharePoint List selected.

I think this is a bug in PowerApps, but thought I'd ask here just to make sure I wasn't overlooking anything. Below is some of the code in my App:

ComboBox:

DisplayFields=["Title","Project_x0020__x0023_"]
SearchFields=["Title","Project_x0020__x0023_"]
DefaultSelectedItems=Parent.Default

DataCard:

DataField="Job"
Update=LookUp(
 Choices([@EquipmentInspectionField].Job),
 Id = DataCardValue21.Selected.ID
)

I even went so far as to make that field not "Required" in the App, but since it is required in the SharePoint List it still gives me the "Job is required" error message.

Here is a short GIF of the issue I am having:

If I do not click in the "Job" ComboBox, I get the "Job is required" even though the correct value appears to be populated."

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

WarrenBelz 156,100 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AlexW8 ,

All you have to do here is simply forget about the lookup column and use the other list being looked up as the Items of the Combo Box - then you can display two fields. Also, unless you are using that Lookup column directly in "Grid View" edit in SharePoint, you most likely do not need it (and I never use the column type).

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Verified answer

AlexW8 9 on at

Like
a
(0)

Report
Copy link

Link copied!
Sorry I did not make it clear, but that was what I was trying to do in the example in my OP. The ComboBox datasource is the List that is the LookUp column in my primary List. This works great, except that if I am editing an existing record, and do not click in the "Job" ComboBox, I get the "Job is required" message, even though a valid value is populated and selected already in the ComboBox. As long as I click on the "Job" ComboBox and select a value, everything works fine.

I spent some time trying to figure this out before I posted it here, but wouldn't you know it, the day after I posted it, I figured it out myself. Here is what I did:

By default, the data source for the ComboBox for a LookUp column is the following:
//Default DataSource for LookUp Column. this will only show one field, not 2. //This is what gets auto-created when you add a new DataCard for a LookUp field. Choices(EquipmentInspectionField.Job)

I manually added the columns to the table returned by the Choices() method. Note: in this case [@colJobsList] is a collection based off the List that is the LookUp column in my primary List. Also in my case, the "Title" column contains the Job Number, the value that is stored in my primary List; and the 'Project #' is the column that I want to add, it is the Job Description.

New datasource for "Job" ComboBox:
//new DataSource for ComboBox AddColumns( Choices(EquipmentInspectionField.Job), "JobDesc", LookUp( [@colJobsList], Title = Value, 'Project #' ) )

That's it. Set your datasource and leave everything else default and it works.

Sorry to make everybody spin their wheels on this. I am slowly but steadily learning this PowerApps stuff.

Was this reply helpful? Yes No