cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rajn
Level: Powered On

SharePoint list update - Patch function not updating empty values for choice fields

Hi

 

I'm updating SharePoint list using the Patch function. The SharePoint list has got many choice columns. When I'm cretaing a new item, I choose certain values for the dropdown and I can see the values getting saved. However if I edit the SharePoint item in PowerApps and remove the dropdown values selected previously and send blank values (no selection made), the SharePoint item still has the old values after save. I don't see the Patch function sending blank values for dropdown. However I can see the text column being set to empty if I remove the value that was previously filled. Issue appears to be with dropdown columns. Is there a fix for this issue? This is how my Patch function looks

 

Patch('My Form',If(MyForm.Mode=FormMode.New,Defaults('My Form'),SharePointIntegration.Selected),MyForm.Updates)

3 REPLIES 3
Community Support Team
Community Support Team

Re: SharePoint list update - Patch function not updating empty values for choice fields

Hi @rajn,

Could you please share a bit more about your scenario?

Do you custom a form for your SP list using PowerApps?

 

I have made a test, and the issue is confirmed on my side. I afraid that the Patch function could not set a blank value for a Choice type column of a SP list within PowerApps currently.

If you would like this fature to be added in PowerApps, please submit an idea to PowerApps Ideas Forum:

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

 

I have made a test on my side, I afraid that there is no way to set a blank value for a Choice type column (same as Person column and Lookup column) within the custom form of a SP list created using PowerApps.

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Rajesh
Level: Powered On

Re: SharePoint list update - Patch function not updating empty values for choice fields

Thanks for the reply. I've used the customize forms option in the SharePoint list to create a custom powerapps form. I feel this is a bug and must be fixed as users can be saving and editing the items multiple times

Community Support Team
Community Support Team

Re: SharePoint list update - Patch function not updating empty values for choice fields

Hi @Rajesh,

The user @AnonyMouse has faced same issue with you, please check the response within the following thread:

https://powerusers.microsoft.com/t5/General-Discussion/Clear-DateField-and-Lookup-Column-value/m-p/1...

 

I have post this issue to my product team already at 07/24/2018, I think the Product team is investigating this issue, if the issue is solved, I would reply here.

 

Best regards,

Kris

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

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,158)