I am getting the following error when I try to Patch the data to the SharePoint list.
Please advise.
The data is a combining from three combo boxes on the input screen (screen 1); only one of the three would have data put it is unknown which until user fills it out.
Each 'Review screen' (screen 2) combo box has a version of the following formula:
Coalesce( PSMCatComCatComCB.SelectedItems.Result, PSMProProfCatComCB.SelectedItems.Result, PSMPurchGrpCatComCB.SelectedItems.Result)
The data is making it from multiple Combo Boxes on Screen 1 to the single Combo Box on Screen 2.
However, when I try to Patch the data to the SharePoint list, I'm getting an error.
Error: "The requested operation is invalid. Server Response: Test List failed: Object must implement IConvertible..."
Patch( 'Test List',
Defaults('Test List'),
{Title: ReviewCompanyNameFLd_2.Text},
{CollectorName: User().FullName},
{DateOfEvent: ReviewDateOfEventDatePicker.SelectedDate},
{CompanyName: ReviewCompanyNameFLd_3.Text},
{PotentialClassification: ReviewPotentialClassificationCB_1.Selected.Value},
{PSMCategoryType: PSMReviewCategoryTypeFld.Text},
{PSMImmediateNeed: PSMReviewImmediateNeedCheckbox.Value},
{PSMCCCategoryCommodity: PSMReviewCatComCBFld},
{PSMCCPurchasingGroup: PSMReviewPurchGrpCBFld},
{PSMCCProcurementProfessional: PSMReviewProProfCBFld},
{SSMCategoryType: SSMReviewCategoryTypeCB.Text},
{SSMImmediateNeed: SSMReviewImmediateNeedCheckbox.Value},
{SSMCCCategoryCommodity: SSMReviewCatComCBFld},
{SSMCCPurchasingGroup: SSMReviewPurchGrpCBFld},
{SSMCCProcurementProfessional: SSMReviewProProfCBFld}
);

Report
All responses (
Answers (