Power Platform Community Forum Thread Details

I used the Filter function to filter a table in Dataverse and used ClearCollect to collect the results. The Filter function returned the correct results I needed, but in ClearCollect, some data is missing. The columns are present, but the data is not shown.

For example,

ClearCollect(
    VarOverLookData,
    Filter(
        MO_OrderLists,
        (Status = "1" || Status = "2" || Status = "3" || Status = "4") &&
        !StartsWith(MD_SKNO, "W") &&
        !StartsWith(MD_SKNO, "Pi") &&
        !StartsWith(MD_SKNO, "Pm") &&
        !StartsWith(MD_SKNO, "P") &&
        !StartsWith(MD_SKNO, "H") &&
        !StartsWith(MD_SKNO, "L") &&
        PRODUCT_TYPE in ComboBox3.SelectedItems &&
        EDTE_YEAR = Dropdown3.Selected.Value &&
        EDTE_MONTH = Dropdown1_1.Selected.Value
    )
);
 
VarOverLookData has everything I need, the data is all there.
 
ClearCollect(
    TestCollect,
    Filter(
        MO_OrderLists,
        (Status = "1" || Status = "2" || Status = "3" || Status = "4") &&
        !StartsWith(MD_SKNO, "W") &&
        !StartsWith(MD_SKNO, "Pi") &&
        !StartsWith(MD_SKNO, "Pm") &&
        !StartsWith(MD_SKNO, "P") &&
        !StartsWith(MD_SKNO, "H") &&
        !StartsWith(MD_SKNO, "L") &&
        PRODUCT_TYPE in ComboBox3.SelectedItems &&
        EDTE_YEAR = Dropdown3.Selected.Value &&
        EDTE_MONTH = Dropdown1_1.Selected.Value
    )
);
 
TestCollect and VarOverLookData has the same filter conditions, but some data is missing.
 
This situation happens a lot. If I Addcolumns and then Clearcollect, it has the same situation. Some works and some not works. How can I make clearcollect show all data.