
Announcements
I am having an issue with Error Checking on drop down columns;
I have the following piece of code attached to the OnSelect value in my Save Icon (it's quite long so didn't want to post the whole thing here as that would probably detract from the question)
Patch('Job Lists', varJob,
{
Contract: E_ContractComboBox.Selected,
'Contract Order Number':E_ContractOrderNumber.Value,
...
}
If(IsEmpty(Errors('Job Lists')),
Navigate(ViewDetailsScreen,ScreenTransition.None)
,Notify(First(Errors('Job Lists')).Message,NotificationType.Error))
The Patch command writes the values to a Dataverse table called "Job Lists" in which both these columns are marked as "Business Required". The problem persists regardless of whether I am creating a new record or updating an existing record.
"varJob" is a variable I populate when the record is selected in the my Filtered Job List gallery.
"Contract" is a lookup column for a table of Active Contracts this is held in the "Job Lists" table.
"Contract Order Number" is a single line text box in the "Job Lists" table.
Both these columns are flagged as "Business Required"
If I blank the "Contract" drop down it still writes the record into the table with what appears to be an empty value against the "Contract", if however I blank the "Contract Order Number" it throws an error saying the "Contract Order Number" is required which is what I would expect to happen as it is also marked as "Business Required".
Any suggestions on how I could resolve this would be greatly appreciated.