Trouble with patching Combo box

[lbolin]

I am trying to patch a combobox and i keep getting errors. I have tried everything i know to do. 

Error:

DataCard values:

[Gochix]

@lbolin ,

The error says - expected type Record, found type text. It looks like you are trying to patch a Choice column with the text.
To fix the issue, try:

Patch(
    YourList,
    Defaults(YourList),
    {Company: {Value: ComboBox1.Selected.Value}}
)

if not try:

Patch(
    YourList,
    Defaults(YourList),
    {Company:ComboBox1.Selected}
)

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

[lbolin]

I'm getting errors when i use either of them:

Here is my full patch code:

IfError(
    Patch(
        'CAR Forms',
        varRecord,
        {
            'Considered Supplier Name 1:': ConSupplier1DataCardValue.Value,
            'Considered Supplier Name 2:': ConSupplier2DataCardValue.Value,
            'Considered Supplier Name 3:': ConSupplier3DataCardValue.Value,
            Status: StatusValue.Value,
            'Anticipated Vendor or Supplier': DataCardValue31.Value,
            'Anticipated SAP Vender #:': 'AnticipateSAPVender#DataCardValue'.Value,
            //Reviews
            'IT Review By': ITReviewByTextInput.Value,
            'Legal Review By': LegalReviewByTextInput.Value,
            'Financial Reviewed By': FinanicalReviewByTextInput.Value,
            //Approval OF Bid Waivers
            AOBW_President_Approver: PresidentApprovalOfBidWaiverInput.Value,
            AOBW_CFO_Approver: CFOApprovalOfBidWaiversTextInput.Value,
            //Competitive Bid Waiver
            'Vender(s):': VendorDataCardValue.Value,
            Amount: AmountDataCardValue.Value,
            'Source Justification': SourceJustificationDropdown.Selected,
            'Price Justification': PriceJustificationDropdown.Selected,
            //Bryce Company Approvals
            BryceComp_SVPReviewer1: BryceComp_SVPReviewer1.Value,
            BryceComp_SVPReviewer2: BryceComp_SVPReviewer2.Value,
            BryceComp_SVPReviewer3: BryceComp_SVPReviewer3.Value,
            BryceComp_SVPReviewer4: BryceComp_SVPReviewer4.Value,
            BryceComp_VPReviewer1: BryceComp_VPReviewer1.Value,
            BryceComp_VPReviewer2: BryceComp_VPReviewer2.Value,
            BryceComp_VPReviewer3: BryceComp_VPReviewer3.Value,
            BryceComp_VPReviewer4: BryceComp_VPReviewer4.Value,
            BryceComp_PresReviewer: BryceComp_PresReviewer.Value,
            BryceComp_CEOReviewer: BryceComp_CEOReviewer.Value,
            //Other
            PurchasingReviewer: PurchasingReview_ReviewerTextInput.Value,
            AssetMangementReviewer: AssetManagement_ReviewerTextInput.Value,
            'CIP/AssetNum': CIPAssetTextInput.Value,
            SAPReqNum: SAPReqNeededTextInput.Value,
            'Project Details': ProjectDetailsDataCardValue.Value,
            Purpose: PurposeCardValue.Value,
            //Plant: PlantComboboxValue.SelectedItems,
            //Company:CompanyComboboxValue.Selected,
        //{Company:{Value:CompanyDataCardValue.Value}},
            //Company: CompanyDropdownValue.SelectedText,
            {Company:CompanyDataCardValue.Selected},
            'Project Leader': ProjLeaderCombobox.Selected.DisplayName
        }
    ),
    Notify(
        FirstError.Message,
        NotificationType.Error,
        2000
    )
);
)
//Create Variable to show on Next Screen
Set(
    varName,
    First(ProjLeaderCombobox.SelectedItems).DisplayName
    //ProjLeaderCombobox.Selected.DisplayName
);
/*Set(
    varCompany,
    CompanyDropdownValue.SelectedText.Value
    //varCompany,First(CompanyComboboxValue.SelectedItems).Value
);*/
Set(
    varPlant,
    PlantDropdownValue.SelectedText.Value
);
Set(
    varCompany,
    CompanyDropdownValue.SelectedText.Value
);
SubmitForm('CAR Form');
ResetForm('CAR Form');
Launch("https://bryceonline.sharepoint.com/Lists/CAR%20Forms/AllItems.aspx")

[Gochix · Accepted solution]

@lbolin ,

That's because you inserted the code wrong.

Try:

IfError(
    Patch(
        'CAR Forms',
        varRecord,
        {
            'Considered Supplier Name 1:': ConSupplier1DataCardValue.Value,
            'Considered Supplier Name 2:': ConSupplier2DataCardValue.Value,
            'Considered Supplier Name 3:': ConSupplier3DataCardValue.Value,
            Status: StatusValue.Value,
            'Anticipated Vendor or Supplier': DataCardValue31.Value,
            'Anticipated SAP Vender #:': 'AnticipateSAPVender#DataCardValue'.Value,
            //Reviews
            'IT Review By': ITReviewByTextInput.Value,
            'Legal Review By': LegalReviewByTextInput.Value,
            'Financial Reviewed By': FinanicalReviewByTextInput.Value,
            //Approval OF Bid Waivers
            AOBW_President_Approver: PresidentApprovalOfBidWaiverInput.Value,
            AOBW_CFO_Approver: CFOApprovalOfBidWaiversTextInput.Value,
            //Competitive Bid Waiver
            'Vender(s):': VendorDataCardValue.Value,
            Amount: AmountDataCardValue.Value,
            'Source Justification': SourceJustificationDropdown.Selected,
            'Price Justification': PriceJustificationDropdown.Selected,
            //Bryce Company Approvals
            BryceComp_SVPReviewer1: BryceComp_SVPReviewer1.Value,
            BryceComp_SVPReviewer2: BryceComp_SVPReviewer2.Value,
            BryceComp_SVPReviewer3: BryceComp_SVPReviewer3.Value,
            BryceComp_SVPReviewer4: BryceComp_SVPReviewer4.Value,
            BryceComp_VPReviewer1: BryceComp_VPReviewer1.Value,
            BryceComp_VPReviewer2: BryceComp_VPReviewer2.Value,
            BryceComp_VPReviewer3: BryceComp_VPReviewer3.Value,
            BryceComp_VPReviewer4: BryceComp_VPReviewer4.Value,
            BryceComp_PresReviewer: BryceComp_PresReviewer.Value,
            BryceComp_CEOReviewer: BryceComp_CEOReviewer.Value,
            //Other
            PurchasingReviewer: PurchasingReview_ReviewerTextInput.Value,
            AssetMangementReviewer: AssetManagement_ReviewerTextInput.Value,
            'CIP/AssetNum': CIPAssetTextInput.Value,
            SAPReqNum: SAPReqNeededTextInput.Value,
            'Project Details': ProjectDetailsDataCardValue.Value,
            Purpose: PurposeCardValue.Value,
            //Plant: PlantComboboxValue.SelectedItems,
            //Company:CompanyComboboxValue.Selected,
        //{Company:{Value:CompanyDataCardValue.Value}},
            //Company: CompanyDropdownValue.SelectedText,
            Company:CompanyDataCardValue.Selected,
            'Project Leader': ProjLeaderCombobox.Selected.DisplayName
        }
    ),
    Notify(
        FirstError.Message,
        NotificationType.Error,
        2000
    )
);
Set(
    varName,
    First(ProjLeaderCombobox.SelectedItems).DisplayName
    //ProjLeaderCombobox.Selected.DisplayName
);
/*Set(
    varCompany,
    CompanyDropdownValue.SelectedText.Value
    //varCompany,First(CompanyComboboxValue.SelectedItems).Value
);*/
Set(
    varPlant,
    PlantDropdownValue.SelectedText.Value
);
Set(
    varCompany,
    CompanyDropdownValue.SelectedText.Value
);
SubmitForm('CAR Form');
ResetForm('CAR Form');
Launch("https://bryceonline.sharepoint.com/Lists/CAR%20Forms/AllItems.aspx")

or

IfError(
    Patch(
        'CAR Forms',
        varRecord,
        {
            'Considered Supplier Name 1:': ConSupplier1DataCardValue.Value,
            'Considered Supplier Name 2:': ConSupplier2DataCardValue.Value,
            'Considered Supplier Name 3:': ConSupplier3DataCardValue.Value,
            Status: StatusValue.Value,
            'Anticipated Vendor or Supplier': DataCardValue31.Value,
            'Anticipated SAP Vender #:': 'AnticipateSAPVender#DataCardValue'.Value,
            //Reviews
            'IT Review By': ITReviewByTextInput.Value,
            'Legal Review By': LegalReviewByTextInput.Value,
            'Financial Reviewed By': FinanicalReviewByTextInput.Value,
            //Approval OF Bid Waivers
            AOBW_President_Approver: PresidentApprovalOfBidWaiverInput.Value,
            AOBW_CFO_Approver: CFOApprovalOfBidWaiversTextInput.Value,
            //Competitive Bid Waiver
            'Vender(s):': VendorDataCardValue.Value,
            Amount: AmountDataCardValue.Value,
            'Source Justification': SourceJustificationDropdown.Selected,
            'Price Justification': PriceJustificationDropdown.Selected,
            //Bryce Company Approvals
            BryceComp_SVPReviewer1: BryceComp_SVPReviewer1.Value,
            BryceComp_SVPReviewer2: BryceComp_SVPReviewer2.Value,
            BryceComp_SVPReviewer3: BryceComp_SVPReviewer3.Value,
            BryceComp_SVPReviewer4: BryceComp_SVPReviewer4.Value,
            BryceComp_VPReviewer1: BryceComp_VPReviewer1.Value,
            BryceComp_VPReviewer2: BryceComp_VPReviewer2.Value,
            BryceComp_VPReviewer3: BryceComp_VPReviewer3.Value,
            BryceComp_VPReviewer4: BryceComp_VPReviewer4.Value,
            BryceComp_PresReviewer: BryceComp_PresReviewer.Value,
            BryceComp_CEOReviewer: BryceComp_CEOReviewer.Value,
            //Other
            PurchasingReviewer: PurchasingReview_ReviewerTextInput.Value,
            AssetMangementReviewer: AssetManagement_ReviewerTextInput.Value,
            'CIP/AssetNum': CIPAssetTextInput.Value,
            SAPReqNum: SAPReqNeededTextInput.Value,
            'Project Details': ProjectDetailsDataCardValue.Value,
            Purpose: PurposeCardValue.Value,
            //Plant: PlantComboboxValue.SelectedItems,
            //Company:CompanyComboboxValue.Selected,
        //{Company:{Value:CompanyDataCardValue.Value}},
            //Company: CompanyDropdownValue.SelectedText,
            Company: {Value: CompanyDataCardValue.Selected.Value},
            'Project Leader': ProjLeaderCombobox.Selected.DisplayName
        }
    ),
    Notify(
        FirstError.Message,
        NotificationType.Error,
        2000
    )
);
Set(
    varName,
    First(ProjLeaderCombobox.SelectedItems).DisplayName
    //ProjLeaderCombobox.Selected.DisplayName
);
/*Set(
    varCompany,
    CompanyDropdownValue.SelectedText.Value
    //varCompany,First(CompanyComboboxValue.SelectedItems).Value
);*/
Set(
    varPlant,
    PlantDropdownValue.SelectedText.Value
);
Set(
    varCompany,
    CompanyDropdownValue.SelectedText.Value
);
SubmitForm('CAR Form');
ResetForm('CAR Form');
Launch("https://bryceonline.sharepoint.com/Lists/CAR%20Forms/AllItems.aspx")

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

[lbolin]

Wow. Thanks it worked. I do have one more question how do I get my Set Functions to work with my combo boxes. The varName doesn't have any errors but I am sure it is correct. I am using these variables to show in a text box in another screen.

[lbolin]

In Plant and Company i only have one column. And I am not sure what the column name would be. 

[Gochix]

@lbolin ,

Search for varPlant and varCompany variables in:

The error could appear if you are setting the same variable in different places within the app, but different formats.
_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

[lbolin]

I am using the same patch function on several different save buttons on the form. When I search it says there Blank. 

[Gochix]

@lbolin ,

I understand that, but check if on each of those save buttons the varPlant variable is set the same way.

If there is a difference how the variable is set across the buttons then you will get this error. 
You can't set the variable as text string and then later somewhere else as Record etc.
_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

[lbolin]

Ok I check all of them and change them and the error went away. Thanx a bunch.