cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Two Colums in a combobox

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

 

 

 

 

 

 

2 REPLIES 2
Impactful Individual
Impactful Individual

Hi @Spikenaylor 

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

Annotation 2019-12-19 095327.png

Annotation 2019-12-19 095357.png

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."

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

 

 

 

 

 

 

 

 

 

 

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (49,556)