Skip to main content

Notifications

Community site session details
Power Automate - General Discussion
Answered

Update sharepoint list item fields to blank/null

Like (8) ShareShare
ReportReport
Posted on 3 Jul 2022 02:29:25 by 16

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!

  • apulsobar Profile Picture
    2 on 04 May 2024 at 07:17:51
    Re: Update sharepoint list item fields to blank/null

    Thank you for your help.

  • SleepyLibrarian Profile Picture
    13 on 03 May 2024 at 21:55:50
    Re: Update sharepoint list item fields to blank/null

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

  • Community Power Platform Member Profile Picture
    on 02 Feb 2024 at 00:00:58
    Re: Update sharepoint list item fields to blank/null

    Amazing! works perfectly. Thank you!

  • jiwhite Profile Picture
    498 on 06 Dec 2023 at 18:09:27
    Re: Update sharepoint list item fields to blank/null

    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.

     

  • jiwhite Profile Picture
    498 on 05 Dec 2023 at 19:26:03
    Re: Update sharepoint list item fields to blank/null

    Any luck with multiline columns?

  • nchambe Profile Picture
    32 on 10 Jan 2023 at 12:55:04
    Re: Update sharepoint list item fields to blank/null

    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

  • Verified answer
    v-jefferni Profile Picture
    on 05 Jul 2022 at 09:26:44
    Re: Update sharepoint list item fields to blank/null

    Hi @EdNYC ,

     

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

     

    Best regards,

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,780 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,093 Most Valuable Professional

Leaderboard