Missing column. Your formula is missing a column

(0) Share

Report

Posted on by CU12011522-0

It gives me an error:

Invalid argument type. Expecting a Record value, but of a different schema.

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

Formula:

Patch(
ExpenseH,
LookUp(ExpenseH, ID = varSelectedRequests.ID),
{
Department: varSelectedRequests.Department,
Status: If(
IsBlank(varNextApprover),
"Approved",
"Pending on " & varNextApprover.Role
),
AssignedTo: If(
IsBlank(varNextApprover),
Blank(),
{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.f|membership|" & varNextApprover.User,
DisplayName: varNextApprover.User,
Email: varNextApprover.User
}
),
CurrentStep: varCurrentStep + 1
}
);

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Kalathiya 1,456 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello @CU12011522-0,

The error happens because SharePoint only requires the Claims property to save a Person/Group column. Other fields like DisplayName, Email, Department, JobTitle, or Picture are optional and can be left blank.

Another issue is in the formula is that varNextApprover.User is a record, so you can’t use it directly. You need to expand the correct property. for example varNextApprover.User.Email

Please try below formula,

Patch(ExpenseH, LookUp(ExpenseH, ID = varSelectedRequests.ID), { Department: varSelectedRequests.Department, Status: If(IsBlank(varNextApprover),"Approved","Pending on " & varNextApprover.Role), AssignedTo: If(IsBlank(varNextApprover), Blank(), { '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims: "i:0#.f|membership|"& varNextApprover.User.Email,//replace this with your expanded filed name 'varNextApprover.User.Email' Department: "", DisplayName: varNextApprover.User.DisplayName, //replace this with your expanded filed name 'varNextApprover.User.DisplayName' Email: varNextApprover.User.Email,//replace this with your expanded filed name 'varNextApprover.User.Email' JobTitle: "", Picture: "" } ), CurrentStep: varCurrentStep + 1 } );

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

---------------------------------------------------------------------------------

📩 Need more help? Mention @Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping!

Was this reply helpful? Yes No
Kalathiya 1,456 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@CU12011522-0

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

---------------------------------------------------------------------------------

📩 Need more help? Mention @Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping!

Was this reply helpful? Yes No