Hi everyone,
as im getting the Message that with February the new Analysis Engine will be set for PowerApps, i gave it a try prior holidays -
at first it looked like everything is working fine, but today i realized that i got problems when pulling Data from Dataverse in a Stacked gallery..
Prior activation of the new engine, the gallery looked like that:
Basically Dynamic gallery representing selected Teams Horizontal.
In this Gallery, there is a second Gallery representing the Days of the selected Month
linked to the second gallery is a Dataverse Table (Scheduling Database), filtering for Team + Day of Gallery Item to get the Linked Projects (so can be more then 1 per day)
The Projects of the Scheduling Database are, of course, linked to the Company "MAIN" Table representing all Projects and Project Data
In the Second Gallery i have a Textfield with this code, showing all Projects of the day:
If(
!IsBlank(First(ThisItem.Anmerkung));
Concatenate(
Concat(
ThisItem.Anmerkung;
Anmerkungen;
Char(10)
);
Char(10);
Char(10)
)
) & IfError(
If(
!IsBlank(First(ThisItem.Projekte));
Concat(
ThisItem.Projekte;
If(
IsBlank(Kostenstelle.Document_Location);
"Ordnerstruktur fehlt!" & Char(10);
""
) & Kostenstelle.b_nummer & Char(10) & Kostenstelle.BA & If(
!IsBlank(Kostenstelle.BA);
Char(10)
) & Kostenstelle.b_name & Char(10) & Switch(
ThisItem.Gewerk;
"Tiefbau";
Kostenstelle.Anmerkung_Tiefbau;
"Floating";
Kostenstelle.Anmerkungen_Float;
"Spleiß";
Kostenstelle.Anmerkungen_Spleiß
) & Char(10) & Char(10)
)
);
""
)
Additionally here the code of the second Gallery, so you see how Projects are getting Populated:
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(
Partie_Einteilung_Database; //Scheduling Dataverse Table
Partie = ThisItem.Anzeigetext && Start_Date <= (var_date + Value) && (Start_Date + Umsetzungsdauer) > (var_date + Value)
);
Anmerkung;
Filter(
Partie_Einteilung_Database;
FeldID = Concatenate(
ThisItem.Anzeigetext;
"-";
(var_date + Value)
) && !IsBlank(new_anmerkungen)
)
)
with new engine turned on, it still recognizes that there are projects in the actual day CountRows(ThisItem.Projekte) in a textfield gives the correct amounts
but i cant access the data underneath..
really need your Help with that,
Thanks in advance
