ComboBox deletes few columns from my collection

(0) Share

Report

Posted on by CU19111450-0

Hi all,

I've got quite a problem in my project. I'm getting data from Excel file to a collection - colExcelErrors.

--- code for getting data to colExcelErrors

ClearCollect(
        colExcelErrors,
        AddColumns(
            Filter(
                Query1,
                Country = Country
            ),
            DisplayProcess,
            Proces,
            DisplayError,
            Error
        )
    )

---

The columns are:

Enabled - boolean

Active_since - DateTime

Active_until - Datetime

Error - String

Error_ID - Number

Proces - String

Weight - Decimal

additionally I'm adding two columns (needed for logic outside of the problem) :
DisplayError - String - the same value as Error

DisplayProcess - String - the same value as Proces

Then I'm using Form and one of the DataCards has a ComboBox with 'Items' property set to the mentioned collection. DisplayFields is set to "DisplayError".

When I'm checking the collection in the Variables tab it has got all the columns that I need but when I check the record selected in the ComboBox it only has these columns:
Active_since
Active_until
DisplayError
Proces
Weight

The Weird part is that it doesn't have Error but has DisplayError, it's the other way around for Proces. It is always selecting these columns - I've tried to create a sub collection for filtering and nothing changed.

I will be grateful for any ideas :)

Best Regards,
Mateusz

Categories:

Building Power Apps

General topics

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

11manish 2,484 on at

Like (1)

Report
Copy link

Link copied!

This is most likely not a problem with your collection. The collection appears to be correct.

The issue is that ComboBox.Selected is returning a projected/optimized record containing only some fields, which is a known Power Apps behavior.

The most reliable solution is to use a unique key (such as Error_ID) and perform a LookUp() back against colExcelErrors whenever you need the full record.

This avoids relying on the schema returned by ComboBox.Selected.

Was this reply helpful? Yes No
Suggested answer

CU19111450-0 5 on at

Like (1)

Report
Copy link

Link copied!

Hi @11manish,

Thanks a lot for the answer. You are correct and this was the issue.

Due to some additional logic I needed to create an If in the "Items" property of the ComboBox and it resulted in the "optimized" record being returned...

In my case I created a 'joint' collection that had columns from both datasources and used this collection as a "unified" data source form the ComboBox - it also worked.

It is a little unnerving that this is a problem, but well. Thanks again!

Best Regards,
Mateusz

Was this reply helpful? Yes No