Unable to Set SharePoint Person Column to Blank in Complex App with Multiple SharePoint Lists

(0) Share

Report

Posted on by TB-04090902-0

Hello Power Apps Community,

I have developed a Power Apps application that connects to more than 20 SharePoint lists in the backend. The app is quite complex, and I am facing a persistent issue specifically with updating a SharePoint Person (People Picker) column to be blank.

Here is what I have tried so far:

Using the Patch function in Power Apps to update the Person column to blank.
Building conditions on the Data Card Update property of the form to set the Person column as blank.
Setting up a Power Automate flow triggered from within the app to update the Person column to blank.

In all these attempts, while I am able to update other fields and records successfully, the Person column refuses to be cleared (set to blank). The update operation completes without errors, but the Person column value remains unchanged.

Interestingly, when I build a new, simpler app (outside of this complex app) connected to the same SharePoint list, all these methods to clear the Person column work perfectly fine.

I have never experienced this issue in any app I have built in the past, so I am quite surprised and puzzled by this unusual behavior in this particular app.

This leads me to believe the issue might be related to the complexity of the app or how the data connections and forms are configured in this larger app.

Has anyone encountered a similar issue or have suggestions on how to reliably clear a SharePoint Person column in a complex Power Apps app environment?

Any help or pointers would be greatly appreciated!

Thank you.

Admin Screen Cont...

Categories:

Building Power Apps

I have the same question (1)

All responses (2)

Answers (0)

Suggested answer

WarrenBelz 154,496 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @TB-04090902-0,

You have not supplied your Patch code, but this should work (it does here when tested) - assuming it is a single choice field
Patch( SPList, LookUp( SPList, YourLookUpHere ), {YourPersonField: Blank()} )

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
WarrenBelz 154,496 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @TB-04090902-0,

A quick follow-up to see if you received the answer you were looking for. Happy to assist further if not.

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