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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Update sharepoint list...
Power Automate
Answered

Update sharepoint list item fields to blank/null

(9) ShareShare
ReportReport
Posted on by 18

Just wanted to post a possible "simple" solution to a PA bug/annoyance that has been plaguing users for years based on this forum. It took me months of searching and trying everything to find a solution that works for my own flows.

 

Issue: The expression "null" in update sharepoint item does not actually work for some fields (especially single choice columns, but even multi choice if not done properly). I have seen some solutions using the HTTP request feature but have not used this myself and did not want to complicate my flows.

 

Solution:

- null expression for fields where it works (date, string seem to be ok)

- for multi choice fields select "switch to input entire array" on the right side of the field (looks like a little square with a T inside EdNYC_1-1656815252243.png) first and then use the null expression

- for single choice fields, what worked for me was to create a string variable at the start of the flow with an empty initial value and then I assigned this variable to all the single choice fields that wouldn't clear with the null expression (in the flow it will appear that you are assigning a custom value with the big blue X but checking the list item after running this flow, the choice field has been correct set to no choice)

 

EdNYC_0-1656815186799.png

 

Hope that also works for others and helps someone!

Categories:
I have the same question (0)
  • Verified answer
    v-jefferni Profile Picture
    Microsoft Employee on at

    Hi @EdNYC ,

     

    Thank you so much to provide this intuitive and simple solution. Great work!

     

    Best regards,

  • nchambe Profile Picture
    34 on at

    I ran into this issue myself when trying to clear multiple field types. I blogged solutions for text, date, number, yes/no, choice (both single and multi), and person column types: How to reset a SharePoint column value to blank using Power Automate | NateChamberlain.com

  • jiwhite Profile Picture
    500 on at

    Any luck with multiline columns?

  • jiwhite Profile Picture
    500 on at

    I was able to remove the data from a multiline column by using an HTTP request and passing the body as:

     

     

     

    {"multilineColumnName":""}

     

     

    jiwhite_0-1701886150103.png

    The main advantage of HTTP requests is that you can pass only the columns that you want to change.

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Amazing! works perfectly. Thank you!

  • SleepyLibrarian Profile Picture
    13 on at

    Thank you SO MUCH for posting this. Been tearing my hair out for hours trying to fix this!

  • apulsobar Profile Picture
    2 on at

    Thank you for your help.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 589

#2
Valantis Profile Picture

Valantis 328

#3
David_MA Profile Picture

David_MA 284 Super User 2026 Season 1

Last 30 days Overall leaderboard