Two Colums in a combobox

[Spikenaylor]

Hi there to you all.

I am new to Powerapps

following some tutorials online

Trying to create a Combobox on my main data form using data from another list

All works with one column and it saves the ID from the source list

My columns that I need to display in the Combobox are DetergentBatch and DetergentExpiryDate

How can I tell the combobox to show the two columns

[SeanHenderson]

Hi @Spikenaylor 

Are you trying to create a Double Combobox? Press the fields button and select it from the layout, then select your columns:

The columns in a double box need to come from the same data source and be of the correct data type.

---
Please hit the "Accept as Solution" button if my post answered your question! If my post was helpful please consider giving it a "Thumbs Up."

[Spikenaylor]

got the combox box working by following a youtube video

Got it all working for one combobox using the below as the Items Code

This one is pulling data from the 1st SharePoint List - ApprovedDetergent

Filter(
    SortByColumns(
        ShowColumns(
            AddColumns(
                ApprovedDetergent,
                "Detergent",
                DetergentBatch & " - Expires: " & DetergentExpiryMonth,
                "ExpiryDate",
                DetergentExpiryDate
            ),
            "Detergent",
            "ExpiryDate"
        ),
        "ExpiryDate",
        SortOrder.Descending
    ),
    ExpiryDate >= Today()
)

This works for the 1st Combobox

The 2nd combobox is pulling data from another list - ApprovedSporicidalDisinfectant

Filter(
    SortByColumns(
        ShowColumns(
            AddColumns(
                ApprovedSporicidalDisinfectant,
                "Detergent",
                SporicidalDisinfectantBatch & " - Expires: " & SporicidalDisinfectantExpiryMonth,
                "ExpiryDate",
                SporicidalDisinfectantExpiryDate
            ),
            "Detergent",
            "ExpiryDate"
        ),
        "ExpiryDate",
        SortOrder.Descending
    ),
    ExpiryDate >= Today()
)

Nothing different except names

however I get a Red X and this Error Message

A Column Named 'SporicidalDisinfectantExpiryMonth' already exists.

No idea why this is doing this, Have checked all my data connections and there are no duplicates, cant find this extra column anywhere

The same thing happens when I try a 3rd Combobox for another list - ApprovedDisinfectant

        ShowColumns(
            AddColumns(
                ApprovedDisinfectant,
                "Disinfectant",
                DisinfectantBatch & " - Expires: ",
                "ExpiryDate",
                DisinfectantExpiryDate
            ),
            "Disinfectant",
            "ExpiryDate"
        )

Even Trimming it down, I am still getting the similar error Message, in this case

A Column Named 'DisinfectantExpiryMonth' already exists.

Any ideas anyone or where to look to find these extra columns

Regards