Delegation Issue

(0) Share

Report

Posted on by 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)

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

CU-18081211-6 9,270 Moderator on at

Like (0)

Report

@Privat2020 ,

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

’Resultcolumn’=Blank()

Was this reply helpful? Yes No
Privat2020 57 on at

Like (0)

Report

Hi @gabibalaban,
Thanks for the reply, but still getting the warning.

Was this reply helpful? Yes No
Rhk 133 on at

Like (0)

Report

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

Was this reply helpful? Yes No
AhmedSalih 6,678 Moderator on at

Like (0)

Report

@Privat2020 , what is your Data Source?

Was this reply helpful? Yes No
Privat2020 57 on at

Like (0)

Report

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')

Was this reply helpful? Yes No
Privat2020 57 on at

Like (0)

Report

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

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report
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,

Was this reply helpful? Yes No
Privat2020 57 on at

Like (0)

Report

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

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report
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,

Was this reply helpful? Yes No
Privat2020 57 on at

Like (0)

Report

Hi @v-jefferni,
Thanks for your feedback, i just tried your code, as the columnX; columnY and columnZ are all the Text column, why i m still getting an error (incompatibility)? i can not define for example: columnX.Value
otherwise i think your formula will work.

Was this reply helpful? Yes No