Unanswered

Delegation Warning

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all,
I'm facing delegation issue while patching in look up function can you please help me to resolve this in the code
ForAll(
Gallery.AllItems,
Patch(
SharePointList,
Lookup(
SharePointList,
'Name' = DataCardValue19_7_Name.Text && ID = Value(Label.Text)
),

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

WarrenBelz 154,924 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

Can you please post the full code in Text and also what is 'Name' in the SP list (or is it a Library) ?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Please check the full code

Set(varshowtd,0);
ForAll(
Gallery4_10.AllItems,
Patch(
Task_Details,
LookUp(
Task_Details,
'Project Name' = Label3_10.Text && ID = Value(lblID_2.Text)
),
{StatusDraft: {Value: "Draft"}},
{ProjectId: VarID.ProjectID},
{'Project Name': ComboSelectProject1_12.Selected.'Project Name'},
{'Task Name': TextInput1_TaskName_3.Text},
{'Task Description': TextInput2_12.Text},
//{'Start Date': NewTaskStartDate_10.SelectedDate},
{'Completion Date': DatePicker3.SelectedDate},
{'Actual Efforts': TextInpu_Efforrts_2.Text},
// {'Revised Efforts': TextInputRevisedEfforts_15.Text},
// //{'Percentage Completed': 'TextInput2%Completed_13'.Text},
//{Ratings: Value(TextInputRatings_16.Text)},
//{Role: TaskDetails_Role_8.SelectedText},
{'Priority Task': NewTaskPrioriyty_12.Selected},
//{Status: NewTaskStatus_10.Selected},
{'Task Categorization': drpTaskCategorization_11.Selected},
{Complexity: NewTaskComplexity_13.Selected},
{'Billable Task': drpBillableTask_14.Selected}
//{Technology: NewTaskTechnology_10.Selected},
/*{
'Assigned To': {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.f|membership|" & Lower(ComboAssignTo21.Selected.Mail),
Department: "",
DisplayName: ComboAssignTo21.Selected.DisplayName,
Email: ComboAssignTo21.Selected.Mail,
JobTitle: "",
Picture: ""
}
}
)*/
)
);

Was this reply helpful? Yes No
WarrenBelz 154,924 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@Anonymous ,

What type of field is 'Project Name' and where are the "blue lines" indicating the Delegation issue ?

Set(varshowtd,0); Patch( Task_Details, ForAll( Gallery4_10.AllItems, With( { wID: LookUp( Task_Details, 'Project Name' = Label3_10.Text && ID = Value(lblID_2.Text) ).ID, }, { ID: wID, StatusDraft: {Value: "Draft"}, ProjectId: VarID.ProjectID, 'Project Name': ComboSelectProject1_12.Selected.'Project Name', 'Task Name': TextInput1_TaskName_3.Text, 'Task Description': TextInput2_12.Text, 'Completion Date': DatePicker3.SelectedDate, 'Actual Efforts': TextInpu_Efforrts_2.Text, 'Priority Task': NewTaskPrioriyty_12.Selected, 'Task Categorization': drpTaskCategorization_11.Selected, Complexity: NewTaskComplexity_13.Selected, 'Billable Task': drpBillableTask_14.Selected, 'Assigned To': { '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims: "i:0#.f|membership|" & Lower(ComboAssignTo21.Selected.Mail), Department: "", DisplayName: ComboAssignTo21.Selected.DisplayName, Email: ComboAssignTo21.Selected.Mail, JobTitle: "", Picture: "" } ) } ) )

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

'Project Name' is a SP list and delegation facing in Lookup function:
&& ID = Value(lblID_2.text)

Was this reply helpful? Yes No
WarrenBelz 154,924 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Anonymous ,

I meant the type of field for 'Project Name'. If it is a single Line of Text, disregard, but I am assuming both Label3_10 and lblID_2 are in the gallery ? If so, why bother testing on 'Project Name' when the ID is a unique identifier. To test a theory I have here, just filter on the ID and see if you get the Delegation warning.

Was this reply helpful? Yes No