)
So far so good and it shows me all items in the gallery. In the gallery items I have a checkbox with the following default value:
If(
LookUp('Planning_Input', CAC_SFC = ThisItem.CAC_SFC, Reviewed) = "true",
true,
false
)
which will nicely show a check in case reviewed is true and otherwise empty.
Now I have a checkbox outside of the gallery, named chk_box1
If that is checked I want to exclude from my gallery all the items where reviewed is true. Tried modifying like this:
If(
chk_box1.Value = true,
Sort(
Filter(
'Planning',
StartsWith(Platform, txt_Search_Platform.Text) &&
!(CAC_SFC in Filter('Planning_Input', Reviewed = "true").CAC_SFC)
),
'CAC_Name'
),
Sort(
Filter(
'Planning',
StartsWith(Platform, txt_Search_Platform.Text)
),
'CAC_Name'
)
)
which seems to do the trick but I get a delegation issue. Is there a way to avoid the delegation?
Also tried stuff like using Lookups to Planning_Input, CAC_SFC = ThisRecord.CAC_SFC but all to no avail :(
So basically for the items in the gallery I'm dependent on the reviewed true/false in a different list for CAC_SFC.
Important to note is that the sharepoint list is around 3k records and the users are reviewing items which are stored with their CAC_SFC in the Planning_Input list.
Assuming once everything is reviewed that list will hold the exact same numbers of records but with additional details which we do not want to store in the Planning list.
