Answered

-The function 'Patch' has some invalid arguments - Invalid argument type. Expecting a record value, but of a different schema - "Missing column. Your formula is missing a column 'JobTitle' with a type of 'Text

(0) Share

Report

Posted on by Manilyn0509

Hi everybody. I'm a first timer doing this thing. Everything is new to me and I'm looking forward to learn from you guys.

I just copied the formula from the tutorial i watched in Youtube. I have copied everything but it gives me errors. I'm so confused because it works well in the tutorial I've watched. What could be the possible mistakes of this?

It says the following:
-The function 'Patch' has some invalid arguments
- Invalid argument type. Expecting a record value, but of a different schema
- "Missing column. Your formula is missing a column 'JobTitle' with a type of 'Text

below is the Formula:

Patch('Employee Request Details', Defaults('Employee Request Details'),
{LeaveType:Gallery4.Selected.LeaveType1},
{LeaveStartDate:StartDate.SelectedDate},
{LeaveEndtDate:EndDate.SelectedDate},
{LeaveDescription: txtLeaveDescription.Text},
{ 'Requested by':
{'@odata.type' : "#Microsoft.Azure.Connectors.Sharepoint.SPListExpandedUser",
Claims: "i:0#.f|membership|" & Lower(User().Email),
Department: "",
DisplayName: User().FullName,
Email: User().Email,
Jobtitle: ".",
Picture: "."}},
{'Approved By':
{'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExapandedUser",
Claims: "i:0#.f|membership|" & Lower(_selectedApprover.Mail),
Department: "",
DisplayName: _selectedApprover.DisplayName,
Email: _selectedApprover.Mail,
Jobtitle: ".",
Picture: "."}})

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

WarrenBelz 154,793 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @Manilyn0509 ,

You might try a capital T in JobTitle

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.

Was this reply helpful? Yes No
Manilyn0509 97 on at

Like (0)

Report
Copy link

Link copied!

OMG! It solved! Thank you so much Sir @WarrenBelz You are Awesome!

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

Like (1)

Report
Copy link

Link copied!

No problem @Manilyn0509 ,

The error you were getting showed this

"Missing column. Your formula is missing a column 'JobTitle' with a type of 'Text'"

Was this reply helpful? Yes No
Manilyn0509 97 on at

Like (0)

Report
Copy link

Link copied!

I didn't expect it to be like that Sir 😅. I really appreciate you reply to a newbie like me.

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

Like (0)

Report
Copy link

Link copied!

Patch(
Table5, Defaults(Table5),
{'Leave Type': Gallery11.Selected.'Leave Type'},
{'From Date': StartDate.SelectedDate},
{'To Date': EndDate.SelectedDate},
{'Leave Title': txtLeaveTitle.Text},
{'Leave Description': txtLeaveDetail.Text},
{
'Requested By': {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "1:0#.f|membership|" & Lower(User().Email),
DisplayName: User().FullName,
Email: User().Email,
JobTitle: " ",
Picture: " "
}
},
{
'Requested To': {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "1:0#.f|membership|" & Lower(_selectedApprover.Mail),
DisplayName: _selectedApprover.DisplayName,
Email: _selectedApprover.Mail,
JobTitle: " ",
Picture: " "
}
},
)

It show character used in the formula are in unexpected way, Please help me in this

Was this reply helpful? Yes No