Blank Value in Look up Field

(0) Share

Report

Posted on by maries1986

162

Hi everyone,

I managed to get my powerapp form to update a look up field in sharepoint using the following:-

{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id:DataCardValue60.Selected.ID,
Value:DataCardValue60.Selected.Parent_x0020_Host}

the problem i have is if i delete the combo box value......it wont update with a blank value. Sharepoint grid view also will not allow this stating " is not a value

if i change the column settings to.....Allow multi values......it will let me delete the field in grid view but then all the other functions break, I cant update the field. or change it.

I just want to be able to unselect a value in the combo box and SP to update with blank. even if i could just get SP to let me delete the value in grid view.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Ram Prakash Duraisamy 5,891 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @maries1986,

Try using Reset(comboBoxField) to set value to Null. Once you done this, you can check the field and patch the same to SP.

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @maries1986 :

Please turn on the formula-level error management and try again:

Best Regards,

Bof

Was this reply helpful? Yes No