Help with delegation filtering for Date Range

(0) Share

Report

Posted on by TSte

242

Hello,

i have a Gallery with code below in its item's Property..

Displaying the days of actual month + Teams (Anzeigetext) and collecting Projects assigned to specific day and team (Dataverse Table), either Start_Date on the day, or longer project and its Project duration on it..

AddColumns(
    Sequence(
        Day(
            DateAdd(
                DateAdd(
                    Date(
                        Year(var_date);
                        Month(var_date);
                        1
                    );
                    1;
                    TimeUnit.Months
                );
                -1;
                TimeUnit.Days
            )
        );
        0;
        1
    );
    Datum;
    var_date + Value;
    Gewerk;
    ThisItem.Leistungsfeld;
    Ausführende;
    ThisItem.Anzeigetext;
    ID;
    Concatenate(
        ThisItem.Anzeigetext;
        "-";
        var_date + Value
    );
    Projekte;
    Filter(
        Sort(
            Filter(
                Partie_Einteilung_Database;
                Partie = ThisItem.Anzeigetext;
                !IsBlank(Umsetzungsdauer)
            );
            Start_Date;
            SortOrder.Descending
        );
        Start_Date <= DateAdd(
            var_date;
            Value
        ) && calc_end_Date > DateAdd(
            var_date;
            Value
        )
    );
    Anmerkung;
    Filter(
        Sort(
            Filter(
                Partie_Einteilung_Database;
                Partie = ThisItem.Anzeigetext;
                !IsBlank(new_anmerkungen)
            );
            Start_Date;
            SortOrder.Descending
        );
        Start_Date = DateAdd(
            var_date;
            Value
        )
    )
)

the DateAdd in the filter for "Projekte" is not delegable are there other ways how i could solve this?

I had other versions of this code:

Start_Date <= (var_date + Value) && 
(Start_Date + Umsetzungsdauer) [instead of calc_end_Date] > (var_date + Value)
 
in this case only (Start_Date + Umsetzungsdauer) was marked to have delegation problems,
so i decided to exchange it with a Dataverse column and do the calculation there, so the new formular looked like that:
 
Start_Date <= (var_date + Value) &&
calc_end_Date > (var_date + Value)
 
using this formular i then got a runtime error on labels in the gallery, but not in the code it self:
 
A binary operator with incompatible types was detected. Found operand types 'Edm.DateTimeOffset' and 'Edm.Int32' for operator kind 'Add'.
 

Is there a way to solve this - getting it non delegable and not getting any error 

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

WarrenBelz 155,378 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @CU23070453-0,

I have tried to make this Delegable - note free-typed, so watch brackets, separators etc
AddColumns( AddColumns( Sequence( Day( DateAdd( DateAdd( Date( Year(var_date); Month(var_date); 1 ); 1; TimeUnit.Months ); -1; TimeUnit.Days ) ); 0; 1 ); _Date; DateAdd( var_date; Value ); _Partie; Sort( Filter( Partie_Einteilung_Database; Partie = ThisItem.Anzeigetext ); Start_Date; SortOrder.Descending ) ); Datum; _Date; Gewerk; ThisItem.Leistungsfeld; Ausführende; ThisItem.Anzeigetext; ID; ThisItem.Anzeigetext & "-" & _Date; Projekte; Filter( _Partie; Start_Date <= _Date; calc_end_Date > _Date; !IsBlank(Umsetzungsdauer) ); Anmerkung; Filter( _Partie; Start_Date <= _Date; !IsBlank(new_anmerkungen) ) )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn Buy me a coffee

Was this reply helpful? Yes No
TSte 242 on at

Like (0)

Report
Copy link

Link copied!

hi, and thank you very much for that fast response!

unfortunately its arguing about Value

it says name invalid, Value not recognized..

Was this reply helpful? Yes No
WarrenBelz 155,378 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @CU23070453-0,

I have had another attempt at the structure - as noted before, this is really to give you an idea of a possible way to manage the Delegation issue - I cannot see your data, so some elements may not be correct.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
TSte 242 on at

Like (0)

Report
Copy link

Link copied!

Thanks!

Did need a little adaption, but basically that way the delegation problems where solved!

best regrads

Thomas

Was this reply helpful? Yes No