Power Platform Community Forum Thread Details

tso i have a textcanvas with this value in my gallery:

If(
    IsBlank(LookUp(
        BoBCoCheckupDetails;
        CheckupHeaderCode.CheckupHeaderCode = varCheckupHeaderCode &&
        ControleDetailCode.ControleDetailCode = ThisItem.ControleDetailCode;
        'Modified On'
    ));
    DateTimeValue("1900-01-01");
    LookUp(
        BoBCoCheckupDetails;
        CheckupHeaderCode.CheckupHeaderCode = varCheckupHeaderCode &&
        ControleDetailCode.ControleDetailCode = ThisItem.ControleDetailCode;
        'Modified On'
    )
) the modified on gets updated when i press the verwerkOk button that has this code (it also sits in my gallery) Patch(
    BoBCoCheckupDetails;
    Defaults(BoBCoCheckupDetails);
    {
        CheckupDetailCode:  varObjectNoControle&"-"&Text(Now(); "yyyymmdd-hhmmss")&"-"&varGebruiker&"-"&ThisItem.ControleDetailCode;
        ControleItemDescription: LookUp(BoBCoControleItems; ControleItemCode = ThisItem.ControleItemCode.ControleItemCode;ControleItemDescriptionNL);
        CheckupResult: "Ok";
        CheckupRemarks: "Veld nog te voorzien";
        CheckupHeaderCode: LookUp(BoBCoCheckupHeaders; CheckupHeaderCode = varCheckupHeaderCode);
        ControleDetailCode: LookUp(BoBCoControleDetails; ControleDetailCode= ThisItem.ControleDetailCode)
    }
);;
Set(
    varControleVisibility;
    false
);;
Reset(Gallery7_2) now i want to filter my items of the gallery so that the items with my newest date gets on the bottom of the gallery. Gallery4_2.Selected.BoBCoControleDetails (this is what i have now in my gallery) 
 
now i thought i could just filter on the textcanvas but it can't because i get a circular reference
 
can somebody help me please!!

Categories:

Building Power Apps

Hi PD-08011026-0,

I think it is a circular reference issue:

Create the Collection: Add this code to your screen's OnVisible property or within the OnStart property of the app

ClearCollect(
colCheckupDetails,
AddColumns(
BoBCoCheckupDetails,
"ModifiedOnComputed",
If(
IsBlank(
LookUp(
BoBCoCheckupDetails,
CheckupHeaderCode.CheckupHeaderCode = varCheckupHeaderCode &&
ControleDetailCode.ControleDetailCode = ControleDetailCode,
'Modified On'
)
),
DateTimeValue("1900-01-01"),
LookUp(
BoBCoCheckupDetails,
CheckupHeaderCode.CheckupHeaderCode = varCheckupHeaderCode &&
ControleDetailCode.ControleDetailCode = ControleDetailCode,
'Modified On'
)
)
)
);

pls try and let me know if you have issues.