@Fabian Heil,
Firstly, please post all code in Text - I cannot guarantee this for spelling as I OCR'd it from a very small image. I have assumed your code is valid, although I am puzzled why you have used
Concat when you can use the
in filter directly on the collection table (still not Delegable however). I have "pre-filtered" with the Delegable part (the date range) and this needs to return less than your Delegation limit to allow the bottom filter to return the full data set (there is no workaround if it does not).
Note also that a Collection is a Delegation limit in itself.
With(
{
wDay:
DateAdd(
varFirstDayOfWeek,
6,
Days
)
},
With(
{
wList:
Filter(
'RIS - BTB Mitarbeiters',
Datum >= varFirstDayOfWeek &&
Datum <= wDay
)
},
ForAll(
Filter(
wList,
Mitarbeiter.'Primäre E-Mail-Adresse' in
Concat(
colETimeMitarbeiter,
Mitarbeiter.'Primäre E-Mail-Adresse',
";"
)
) As aCol,
Collect(
colETimeSchichten,
{
rtID: aCol.'RIS - BTB Mitarbeiter',
rtTvp: aCol.'BTB ID'
}
)
)
)
)
------------------------------
Warren Belz
Queensland Australia
------------------------------
Original Message:
Sent: Nov 18, 2022 10:21 AM
From: Fabian Heil
Subject: Delegation - User in Collection
In many cases, i am collecting multiple users in a collection (Dataverse lookup to Users table).
For these users i want to collect another collection. The only way i was getting it to work, is using ForAll and the "IN" operator with a concatted email adresses.
This is not delegable.
Do you have any better way to achieve this with delegation?
------------------------------
Fabian Heil
------------------------------