web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Can't change SharePoin...
Power Apps
Answered

Can't change SharePoint List column to blank.

(0) ShareShare
ReportReport
Posted on by 457

NEVER MIND. Looks like formula level error management did work. It just took some time to kick in. 

Not sure how to delete a post here.  

 

I have a SharePoint Asset List for employee assets. When the employee leaves and the asset becomes available, I need to change the FULL NAME field to blank. Removing the name with the Power App doesn't take hold and the user's name remains. 

 

This FULL NAME field is a Lookup from another list of employees. The Asset list does allow for blank fields in all columns. I have a number of items in the list with blanks in the FULL NAME column. I came across this post which suggested enabling Formula-level error management. This didn't help my problem. I'm certain that I've been able to 'blank-out' the FULL NAME column before. 

Categories:
I have the same question (0)
  • Pstork1 Profile Picture
    68,707 Most Valuable Professional on at

    Are you changing it by setting the field to blank and submitting the form?  Or using some form of Patch?  Can you show us the formula being used.  Since its a lookup column I don't think you can just set it to Blank().  You need to use some record format.

  • Verified answer
    v-qiaqi@microsoft.com Profile Picture
    on at

    Hi @anthonys123,

    Thanks for your sharing. I will help you close this case.

    Regards,

    Qi

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 721 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 320 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard