Answered

Patch cording

(0) Share

Report

Posted on by LG-10061841-0

Hi,
I was trying to create an HR system using Power Apps. In order to apply for leaves and approved by the manager a Patch code was entered. I have obtained support from Corpilot. However, there were errors even though I tried multiple times. 
 
Could someone please help to sort this out. The coding is below;
 
Patch('Leave Requests List',Defaults('Leave Requests List'),{Employee:User().Email,'Start Date':StartDatePicker.SelectedDate,'End Date':EndDatePicker.SelectedDate,'Days Requested':DateDiff(StartDatePicker.SelectedDate,EndDatePicker.SelectedDate,TimeUnit.Days)+1,'Status':"Pending"(,Manager:with({mgrEmail:LookUp('Employees List',Email=User().Email,Manager)},{'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",Claims: "i:0#.f|membership|" & mgrEmail,DisplayName: mgrEmail,Email: mgrEmail}
})
 

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @LG-10061841-0,

You have not posted what the error were and I am assuming a few field types here, but try this for a start (please note that is is always advisable to parse the code as below and you will see structure errors more easily)
With( { _Manager: LookUp( 'Employees List', Email = User().Email, Manager ), _Days: DateDiff( StartDatePicker.SelectedDate, EndDatePicker.SelectedDate, TimeUnit.Days ) + 1, }, Patch( 'Leave Requests List', Defaults('Leave Requests List'), { Employee: User().Email, 'Start Date': StartDatePicker.SelectedDate, 'End Date': EndDatePicker.SelectedDate, 'Days Requested': _Days, 'Status': "Pending", Manager: { Claims: "i:0#.f|membership|" & Lower(_Manager.Email), DisplayName: _Manager.DisplayName, Email: _Manager.Email, Department: "", JobTitle: "", Picture: "" } } ) )

Please ✅ Does this answer your question 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 answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
LG-10061841-0 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Dear WarrenBelz,

Thank You so much, Still have errors. if you can please advise. please see below errors,

The expression is intended to create a new leave request record in the 'Leave Requests List' data source when a button is selected. It looks up the current user's manager from the 'Employees List' based on the user's email, calculates the number of days requested for leave (including both start and end dates), and then patches a new record with details such as the employee's email, leave start and end dates, days requested, status set to "Pending," and manager information formatted with claims and display name.

The errors are:

1. **'_Manager' is not defined**: The variable '_Manager' is used but never assigned or declared, causing a name recognition error.
2. **Invalid use of the '.' operator on error values**: This likely results from trying to access properties of '_Manager', which is undefined.
3. **Invalid arguments to the 'Lower' function**: The argument passed to Lower() is '_Manager.Email', which is invalid because '_Manager' is not defined.
4. **'Patch' function has invalid arguments**: The 'Employee' field is assigned a Text value (User().Email) but expects a Record type.
5. **Use of 'Equals' function incorrectly**: The condition in LookUp uses Equals((Email), (User().Email)), but 'Equals' is not a standard Power Fx function; the correct syntax is Email = User().Email.
6. **Use of StringLiteral and extra parentheses**: StringLiteral() is not a valid function in Power Fx; string values should be enclosed in double quotes directly. Also, there are unnecessary parentheses around variables and values.

In summary, the expression has issues with undefined variables, incorrect function usage, type mismatches, and syntax errors that prevent it from working as intended.

Was this reply helpful? Yes No