Others

How to Patch the Current User in a Power Apps SharePoint Person Column

Phi Hung Vo Oct 8, 2026 870 views

Question details

The user needs to write the currently signed-in user's profile information into a SharePoint Person or Group column using the User() function and Patch in Power Apps.

How to Patch the Current User in a Power Apps SharePoint Person Column

Product: Microsoft Power Apps
Device & OS: not provided
Scenario: Updating a SharePoint list record with the current user's details via a Power Apps canvas app formula.
Observed behavior: The user requires the correct syntax or assistance to successfully patch a complex record type to a SharePoint Person column without encountering formula errors.

Before you start

Before modifying your Power Apps formulas, ensure you have the exact spelling of your SharePoint column names and verify that the destination column is configured to accept 'Person or Group' data types.

Solution 1Recommended

Consult the Power Apps Community for Syntax Assistance

Because SharePoint Person columns require specific complex record syntax that can change based on column settings, the official Power Apps community is the best place to resolve specific formula errors.

Patching a Person column in SharePoint is notoriously tricky because it requires a specific JSON record structure (SPListExpandedUser) rather than a simple text string. When you encounter persistent errors, Microsoft specialists in the community forums can diagnose your exact formula.

Gather your current formula

Copy your current Patch formula, note the exact SharePoint column type configuration, and copy any specific error messages you are receiving in the Power Apps studio.

Visit the community forums

Navigate to the official Microsoft Power Apps Community online and log in with your Microsoft account.

Post your question

Create a new topic detailing your scenario. Include the formula and error message, but ensure you exclude any sensitive company data, user emails, or confidential list names.

Consult the Power Apps Community for Syntax Assistance

Data Privacy: Always redact sensitive personal or organizational information when posting screenshots or code snippets in public forums.

Solution 2

Apply Standard Patch Syntax for Person Columns

While community support is recommended for complex errors, ensuring your basic syntax matches the required structure for a SharePoint Person column resolves most common issues.

Free Microsoft Office alternative

Boost Your Productivity with WPS Office

While Power Apps and SharePoint are highly specific to the Microsoft ecosystem, for all your daily document, spreadsheet, and presentation needs, WPS Office offers a lightweight, highly compatible, and free alternative to Microsoft Office.

1. Download WPS Office: Visit the official website and download the free version of WPS Office.
2. Install the software: Follow the simple on-screen instructions to install the lightweight suite on your device.
3. Open Office files seamlessly: Instantly open and edit your existing Word, Excel, or PowerPoint documents without losing any formatting.

Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx).Lightweight design ensures fast launch times and smooth performance on any operating system.Familiar user interface requires no learning curve, making migration seamless.Free integrated PDF reader and editor for comprehensive document management.

microsoft office alternative - wps office

Frequently Asked Questions

Why do I get an error when patching a string directly to a Person column?

SharePoint Person columns expect a complex record object (SPListExpandedUser) containing specific claims and email properties. Supplying a simple text string causes a type mismatch error in Power Apps.

Can I use the User() function in Power Apps to get the current user's email?

Yes, the User().Email function retrieves the email address of the currently signed-in Power Apps user, which is a required component for constructing the Patch record for a SharePoint Person column.

Where is the best place to find help for complex Power Apps formulas?

The official Microsoft Power Apps Community is the best resource for formula syntax errors. Posting your current formula, column type, and error message there connects you with experts who can provide precise solutions.

Office Quick Solutions