Delegation Issue

[Privat2020]

Hi All,

can anyone help me to overcome the problem of delegation,

i have a warning in that column called "Resultscolumn", below is my code:

Filter(
AddColumns(
Datasource2;
"_OpenTasks";
!IsBlank(
LookUp(
Datasource1;
'columnname1' = Datasource2[@columnname2] And IsBlank('Resultscolumn')
)
)
);
StartsWith(columnA;TextInput1.Text); columnB=TextInput2.Text;_OpenTasks)

[gabibalaban]

@Privat2020 ,

maybe this approach will be helpful, although I think that the delegation problem is beyond this.

’Resultcolumn’=Blank()

[Privat2020]

Hi @gabibalaban,

Thanks for the reply, but still getting the warning.

[Rhk]

Can you explain some more what you are trying to do?

[AhmedSalih]

@Privat2020 , what is your Data Source?

[Privat2020]

Hi @Rhk, @AhmedSalih 

in fact i have two screens and each screen has a gallery, each person has a certain tasks associated, so for example: if Person1 has maximum 3 tasks and if you checked them via checkbox in screen2 and click on save button, then on screen1 the person1 will be hidden in the gallery in screen1 but if you checked only like 2 tasks (as long as it still one left task for him) then in screen1 person1 will still appearing i.e. the person1 will not be hidden. 

i.e. person1 in gallery1 in screen1 will be hidden only when all his tasks have been checked.

, each task in gallery2 (i.e. in screen2) has a checkbox.

and my data source are:  Datasource1 and Datasource2 in screen1 and screen2 respectively,

screen1: gallery1

Person 1

Person 2

screen2: gallery2

Person 1	Task1
Person 1	Task2
Person 1	Task3
Person 2	Task4
Person 2	Task5

as i said in my code that line is warning me due to delegation issue:     And IsBlank('Resultscolumn')

[Privat2020]

@Rhk , @AhmedSalih 

sorry i forget to mention something, that code is on "Items property" in gallery1 screen1.

[v-jefferni]

Hi @Privat2020 ,

Could you please share more details? What is the type of the Resultscolumn? Seems like you are updating this column via Checkbox in the Gallery2, right? If it is a Text column, there should not be delegation warnings, but if it's a Y/N column, you need to change your formula as below:

Filter(
    AddColumns(
        Datasource2;
        "_OpenTasks";
        !IsBlank(
            LookUp(
                Datasource1;
                'columnname1' = ThisRecord.columnname2 And 'Resultscolumn'.Value = false)
            )
        )
    );
    StartsWith(columnA;TextInput1.Text); 
    columnB = TextInput2.Text;
    _OpenTasks 
)

This issue also relates to another thread from yours:

checkbox remain checked - Power Platform Community (microsoft.com)

If the check box value bonds to that Resultcolumn which is Y/N type, it will remain after checking (but still you need to update OnCheck/OnUncheck to update the values)

Hope this helps.

Best regards,

[Privat2020]

Hi @v-jefferni,

Thanks for the reply, i m getting the error from that line of code

actually you are right because that column of tasks is not a Text column i.e. is a column which calculate based on other columns) i.e. it s a combination of three columns and it s formula in sharepoint list is =columnX&columnY&columnZ

[v-jefferni]

Hi @Privat2020 ,

Calculated columns actually are not well supported in PowerApps. You will need to check that value in PowerApps, so it might be:

Filter(
    AddColumns(
        Datasource2;
        "_OpenTasks";
        !IsBlank(
            LookUp(
                Datasource1;
                'columnname1' = ThisRecord.columnname2 And (ColumnX.Value&&ColumnY.Value&&ColumnZ.Value = false))
            )
        )
    );
    StartsWith(columnA;TextInput1.Text); 
    columnB = TextInput2.Text;
    _OpenTasks 
)

Best regards,