Answered

Changing value to blank not updating in SP list

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

The field "Current Report Owner" is a person search field using Combo-box control.

My query is that if the DataCardValue11_3="Data Extract" which is field "Report Type"- then i want the SP list to get updated as BLANK.

I am using the DefaultSelectedItems property here as shown but the values are not getting written over the SP list.

The form does show a blank when working and selecting the Report Type field as Data Extract. And the Current Report Owner cells changes to blank too. The issue however, is that the SP list still reads the old value and does not show blank.

Attaching a GIF- please assist!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous ,

According to your description, let me explain why you encountered this problem.
The point is that you are not using functions that modify data.
The DefaultSelectedItems property cannot modify the data in your data source.
It can only change the value of the "Current Report Owner" control.

So, you could try this:
1\ Open your settings and modify the settings as shown below:

2\ Set the onchange property of the Report Type control to:
If(DataCardValue11_3.Selected.Value="Data Extract",Patch(your data sourse name,ThisRecord,{Current Report Owner:Blank()}));Refresh(your data sourse name)

3\ Set the DefaultSelectedItems property of your Current Report Owner control to:
Parent.Default

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Anonymous

Sorry I missed your message! Yes, you will need to turn on the Formula-level error management feature to get this to store properly.

As for all the rest of it - your datacard for the form is using the Selected property of the combobox control in the Update property, so there is nothing else needed. Certainly do not Patch and then Refresh - this is not only not necessary, but will also impact your performance and other parts of your form.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

@RandyHayes Thank you so much. I realized the same too that PATCH & REFRESH affected my app badly- not just performance but also the malfunction it brought!

Was this reply helpful? Yes No