Delegation Warning to Submit form

[Anonymous]

Hi all,

I need help with the issues that I had to face which is regarding the delegation issue. Below is the issues

and on the Button3 OnSelect, the codes are : 

ClearCollect(LeaveSum,Sum(Filter(LeaveAppliedByUser,LeaveId.Value=Gallery5.Selected.LeaveId && RequestedBy.Email=User().Email),TotalDays));

ClearCollect(TotalLeave,Sum(Filter(BenzahLeaveRequest,LeaveId=Gallery5.Selected.LeaveId),'TotalLeave'));

[WarrenBelz · Accepted solution]

Hi @Anonymous ,

Two things here - firstly Sum() is not Delegable (hence the warning) and also these will return a single value (each), so you can set Variables to them. NOTE - the top filter must return item numbers under your Delegation limit or you will not receive a complete result.

With(
   {
      wList:
      Filter(
         LeaveAppliedByUser,LeaveId.Value=Gallery5.Selected.LeaveId && 
         RequestedBy.Email=User().Email
      )
   },
   UpdateContext(
      {
         varLeaveSum:
         Sum(
            wList, 
            TotalDays
         )
      }
   )
);

With(
   {
      wList:
      Filter(
         BenzahLeaveRequest,
         LeaveId=Gallery5.Selected.LeaveId
      }
   },
   UpdateContext(
      {
         varLeaveDays:
         Sum(
            wList, 
            TotalLeave
         )
      }
   )
);

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[Anonymous]

Hi @WarrenBelz 

I did try your suggestion but unfortunately, there's an error occurs. Can you help me figure out this?

and here is the issue

[WarrenBelz]

@Anonymous ,

Did not copy properly (now fixed). I thought you might have picked that up from the bottom item,

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[Anonymous]

@WarrenBelz  I did copy from top to bottom then there’s an error as mentioned as above. The image that i attached was being crop to show where the exact error is. 

[WarrenBelz]

@Anonymous ,

Did you copy my amended text - it should be produce an error

[Anonymous]

 @WarrenBelz Yes, I did copy and produce an error. What is the issue actually can you explain?

[WarrenBelz]

@Anonymous ,

What is the error and what element does it refer to? Please re-check your values and the code as well.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[Anonymous]

@WarrenBelz Yes, I did check and fix it. Then, when I click Submit button (Button Submit) form here is the error at Runtime,

Below is the code for ButtonSubmit:

Patch(

LeaveAppliedByUser,

Defaults(LeaveAppliedByUser),
{

LeaveType: Gallery5.Selected.LeaveType.Value,
FromDate: StartDate.SelectedDate,
ToDate: EndDate.SelectedDate,
LeaveTitile: txtLeaveTitile.Text,
LeaveDescription: txtLeaveDescription.Text,
Selectedby: Requestedby.Text,
TotalDays:daysdiff+1,
RequestedBy:
{'@odata.type' : "#Microsoft.Azure.Connectors.Sharepoint.SPListExpandedUser",
Claims: "i:0#.f|membership|" & Lower(User().Email),
Department: "",
DisplayName: User().FullName,
Email: User().Email,
JobTitle: ".",
Picture: "."},
RequestedTo:
{'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExapandedUser",
Claims: "i:0#.f|membership|" & Lower(_selectedApprover.Mail),
Department: "",
DisplayName: _selectedApprover.DisplayName,
Email: _selectedApprover.Mail,
JobTitle: ".",
Picture: "."}
}
);
Notify("Leave Applied Successfully", NotificationType.Success);

The above code before this has no issue. After I fix the delegation warning, this is what happening right now and my data cannot store in SharePoint list.

[WarrenBelz]

@Anonymous ,

How is that related to your original post on Delegation issues? Is that one now solved?

Your code (I have parsed below) does not mention either your original collections or the variables I suggested.

Patch(
   LeaveAppliedByUser,
   Defaults(LeaveAppliedByUser),
   {
      LeaveType: Gallery5.Selected.LeaveType.Value,
      FromDate: StartDate.SelectedDate,
      ToDate: EndDate.SelectedDate, 
      LeaveTitile: txtLeaveTitile.Text,
      LeaveDescription: txtLeaveDescription.Text,
      Selectedby: Requestedby.Text,
      TotalDays:daysdiff+1,
      RequestedBy:
      {
        '@odata.type' : "#Microsoft.Azure.Connectors.Sharepoint.SPListExpandedUser",
        Claims: "i:0#.f|membership|" & Lower(User().Email),
        Department: "",
        DisplayName: User().FullName,
        Email: User().Email,
        JobTitle: ".",
        Picture: "." 
      },
      RequestedTo:
      {
         '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExapandedUser",
         Claims: "i:0#.f|membership|" & Lower(_selectedApprover.Mail),
         Department: "",
         DisplayName: _selectedApprover.DisplayName,
         Email: _selectedApprover.Mail,
         JobTitle: ".",
         Picture: "."
      }
   }
);
Notify(
   "Leave Applied Successfully", 
   NotificationType.Success
);

Your error will most likely be one of your values as the basic syntax structure is correct. When you were writing this, did you test each field Patch to see if it was valid?

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps