Yes/No Column Patch not updating based on lookup

[forbudt4u]

Hello, I have looked at other posts and can't quite seem to find the same issue I'm having.  However, I am patching a list that has a couple columns that populate based on the result of a ComboBox selection that looks up info from my Model Library.  One column is a Yes/No column, and the other is a Number column.  In the list I'm updating/patching, the columns are set up the same.  The issue is the patch updates the Number column without any issues, but the Yes/No column will not update.  Below is my code and screenshots from my lookup Library and my List being patched.    

PATCH (bottom two column patches (Calibration Required & Calibration Increment) are the two columns I'm referring to)

Patch(
    'All Asset List',
    Defaults('All Asset List'),
    {
        Title: If(
            IsBlank(AddAssetBarcodeScanbtn.Value),
            AddAssetBarcodeScanTxtInput.Text,
            AddAssetBarcodeScanbtn.Value),
        Holder: O365CboBox.Selected.Title,
        CategoryBK: AddAssetCategoryDrpDwn.SelectedText.Result,
        ManufacturerBK: AddAssetManDrpDwn.SelectedText.Result,
        ModelBK: If(IsBlank(ModelFilterModel),AddAssetModelCmbBx.Selected.Model,
        ModelFilterModel.SelectedText.Result),
        CostBK: Value(AddAssetCostTxtInput.Text),
        DescriptionBK: AddAssetDescriptionTxtInpt.Text,
        Serial_x0023_: AddAssetSerialNumTxtInput.Text,
        Acquired_x0020_Date: AddAssetDatePicker.SelectedDate,
        Status: { Value: AddAssetStatus1DrpDwn.Selected.Value},
        LocationBK: O365CboBox.Selected.Location.Value,
        Asset_x0020_Site: O365CboBox.Selected.Asset_x0020_Site.Value,
        Kits: AddAssetModelCmbBx.Selected.Kits,
        AuditStatus: "Pending",
        'Calibration Required': AddAssetModelCmbBx.Selected.'Calibration Required Asset',
        'Calibration Increment': AddAssetModelCmbBx.Selected.'Calibration Increment'.Value
    }
)

Lookup Model Library Columns (Calibration Required Asset is YES/NO column and Calibration Increment is a Number column).

  - This particular record is set to YES for the Model being a Calibration Required Asset with a Calibration Increment of 365 Days

All Asset List Columns AFTER PATCH (Calibration Required is a YES/NO column and Calibration Increment is a Number column).

  - You can see after the patch , the Calibration Required will NOT update, Calibration Increment WILL Update)

I have attempted using .text, .value, If, Lookup... you name it, within my patch to get the Calibration Required column to update, but I just can't get it to.  Any help or guidance would be appreciated.  

[ganeshsanap]

@forbudt4u Yes/No columns expect either true or false value. Make sure you are passing either true or false correctly. 

What is the output of AddAssetModelCmbBx.Selected.'Calibration Required Asset'? I am guessing it is of type string??

---

If the answer is helpful, please consider giving it 👍. Please click Accept as solution & ‌‌👍 if my answer helped you to solve your issue. This will help others to find the correct solution easily.

Best Regards,

Ganesh Sanap

Blog site 

[forbudt4u]

@ganeshsanap 

I understand the true/false thing, and that's why I mentioned that I tried both lookup and if statements that passed on the true (yes), false (no) values, but I could not get it to work even though the columns are set up the exact same way both in the reference library and patched list.  Regarding your question about the output, the combobox is already referencing the lookup library so it should pass on whatever column info I need after the selected.... ex: AddAssetModelCmbBx.Selected.ColumnInfoNeeded.  This works just fine and the information is patched just fine for the  AddAssetModelCmbBx.Selected.'Calibration Increment'.value column.  Seeing both the reference and patched list columns are set up as YES/NO, you would think it wouldn't be this difficult?

[forbudt4u]

I seem to always find myself not being able to see the forest through the trees.  I ended finding out why this wasn't working.  My AddAssetCmbBx ComboBox can also be populated via a popup filter so people can find models if they only know the category or manufacturer.  So, when I was running my test I was doing exactly that rather than searching for and directly selecting the model in the dropdown, so it was not seeing the selected item.  I ended up adding and OR statement to cover the model being selected via the filter and it's working now.