Canvas app showing optionset value in label

[trjackson77]

I have some code in a canvas app that should return an option set value (YES/NO) from a Dataverse database.  Ultimately I want to place it in a checkbox, Ticked if Choice.Yes, Unticked if Choice.No.

The code only returns null, I can't display it in a text box or checkbox.

Can anyone point me in the right direction, please?

First(
    Filter(
        'Warehouse Collections',
        wc_SalesOrderNumber = ThisItem.'Order Number' && wc_SalesOrderItemNumber = ThisItem.'Order Item Number'
    )
).wc_toCollect

[dpoggemann]

Hi @trjackson77 ,

Is this helpful for you to display the value in dropdown or checkbox?  https://debajmecrm.com/display-two-options-field-of-common-data-service-as-checkbox-on-canvas-app/