cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AnonyMouse
Helper I
Helper I

Clear DateField and Lookup Column value

I have a datefield and lookup column in my form. In the EditForm, after the user clears the datefield column and lookup column to an empty value and save the form, in sharepoint, it still retains the old value. How can I set these fields back to null?

1 ACCEPTED SOLUTION

Accepted Solutions
joshnystrom
Advocate V
Advocate V

Okay, I've done more investigation on what is possible with this approach and here is a (hopefully) simple rollup:

You can reliably clear Person, Choice and Lookup (but still not Date) fields as follows:

Set each corresponding "blank" variable (Person is a Table, the others are individual Records)

Set(
    BlankPerson,
    Table(
        {
            Claims: Blank(),
            DisplayName: Blank(),
            Email: Blank(),
            Department: Blank(),
            Picture: Blank(),
            JobTitle: Blank()
        }
    )
);
Set(
    BlankChoice,
        {
            Id: -1,
            Value: Blank()
        }
);
Set(
    BlankLookup,
        {
            Id: -1,
            Value: Blank()
        }
)

And merge-patching the target list item like so:

Patch(
        'Test List',
        {ID: ItemID},
        {
	    PersonField: BlankPerson,
            ChoiceField: BlankChoice,
            LookupField: BlankLookup
        }
    )

That's all I have so far. I still haven't tested Groups but I suspect they would work fine.

Good luck!

Josh

View solution in original post

15 REPLIES 15
Motz
New Member

One way to do it is to create a local variable using and set that to blank and make the default value for the date control to be the variable you created.

 

UpdateContext({BlankMe:Blank()})

 

Set DefaultDate for DatePicker1 to BlankMe.

 

Whenever you save the form, you'll reset the control.

 

Reset(DatePicker1)

Tried you suggestion. 

In the OnVisible, I set the variale, UpdateContext({BlankMe:Blank()})

In the default property of the datepicker, I set BlankMe

On submit of the button, I have Reset(DatePicker1);SubmitForm(EditForm)

 

But it does not clear the value from the Sharepoint list

v-monli-msft
Community Support
Community Support

Hi @AnonyMouse,

 

I can reproduce your issue. I will report this to pg and see if they have any suggestions.

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I too have this issue, any solutions ?

It has been two weeks... any update on clearing Lookup Column value on SPL via PowerApps?

I thought this was a recent issue but it seems it has been over 7 months that the issue is still going without any solution.

I did few test to on a simple SPL with customized PA form. Where users clear their names from the Person field and save it back to the SPL.

I did try with Patch() and SubitForm().  Both I wasn't able to clear the Person field... or if you prefer to remove the value from that field and keep the value.

@v-monli-msft do you have any update?

I consider this as simple (basic) value assignation that should work properly... but it doesn't.

joshnystrom
Advocate V
Advocate V

Hi all, I found a way to clear Person/People picker fields that doesn't rely on experimental features, nor a Flow, so I thought I'd surface it here. I'm not yet sure if the same approach will work for DateField, LookUp or Group Picker, but hopefully!

My current understanding of my approach makes a few assumptions (I'm not certain whether they are integral to its use):

-You are treating this like a "Complex" data update and are therefore using Patch statements to merge into the existing SP List item
-Your app has a way to detect when the person-picking control was left blank so that you can conditionally change which Patch statement is being executed

-You are using the out-of-the-box people picker or can otherwise tweak my approach to match a "valueless" Person record

All I've done is prep a "BlankPerson" variable that is manually shaped as a single, blanked-out Person record for the SP Person/Group field, as follows:

Set(BlankPerson,Table({'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",Claims:Blank(),DisplayName:Blank(),Email:Blank(),Department:Blank(),Picture:Blank(),JobTitle:Blank()}))

When Patching with this as my payload when the People picker control is left blank, I've been able to Clear the corresponding field on my SP List item.

 

Hope this helps someone!

Josh

 

 

E: In this thread - https://powerusers.microsoft.com/t5/General-Discussion/Clearing-out-people-picker-field/m-p/249368/h... - RandyHayes indicated that this approach is working for LookUp fields as well.

joshnystrom
Advocate V
Advocate V

Okay, I've done more investigation on what is possible with this approach and here is a (hopefully) simple rollup:

You can reliably clear Person, Choice and Lookup (but still not Date) fields as follows:

Set each corresponding "blank" variable (Person is a Table, the others are individual Records)

Set(
    BlankPerson,
    Table(
        {
            Claims: Blank(),
            DisplayName: Blank(),
            Email: Blank(),
            Department: Blank(),
            Picture: Blank(),
            JobTitle: Blank()
        }
    )
);
Set(
    BlankChoice,
        {
            Id: -1,
            Value: Blank()
        }
);
Set(
    BlankLookup,
        {
            Id: -1,
            Value: Blank()
        }
)

And merge-patching the target list item like so:

Patch(
        'Test List',
        {ID: ItemID},
        {
	    PersonField: BlankPerson,
            ChoiceField: BlankChoice,
            LookupField: BlankLookup
        }
    )

That's all I have so far. I still haven't tested Groups but I suspect they would work fine.

Good luck!

Josh

View solution in original post

I tried to clear  a user field but the editor complained about it being a Record and not a Table.

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Did you miss the call? Check out the recording here!

Top Solution Authors
Top Kudoed Authors
Users online (19,821)