Answered

Blank() value is not update on decimal type column in sql table

(1) Share

Report

Posted on by garhe27

Hi Team,

I am not able to store blank() or NULL into decimal type column in sql . It is update only 0.00 value while apply patch. Please help me to fix

Set(var_d,Blank());
Patch(Local_Portfolio_Information_Editable,LookUp(Local_Portfolio_Information_Editable,ID="60796_19580_70000SE"),{MSLP_Plus_Value_for_Creation:Value(var_d)})
 
Thanks,
Chitrakant

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Suggested answer

SpongYe 5,616 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Could you please check if the default value in the SQL table is set to NULL/blank?
In my case, I have a SQL table where I can define the default value for a column.
If the Patch function submits Blank(), the SQL column may override it with its predefined default value.
Below is an example of a SQL table where a default value is mandatory:

Hope this helps.

Was this reply helpful? Yes No
Verified answer

MS.Ragavendar 5,004 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

SQL Decimal columns do not accept Blank() or Null directly in Power Apps.

Instead, when you pass Blank(), Power Apps converts it to 0.00, as SQL treats NULL and 0 differently.

Try this formula

Approach 1

Patch(
Local_Portfolio_Information_Editable,
LookUp(Local_Portfolio_Information_Editable, ID = "60796_19580_70000SE"),
{ MSLP_Plus_Value_for_Creation: Blank() }
)

Approach 2

Patch(
Local_Portfolio_Information_Editable,
LookUp(Local_Portfolio_Information_Editable, ID = "60796_19580_70000SE"),
{ MSLP_Plus_Value_for_Creation: Text(Blank()) }
)

If your column is set to NOT NULL, it cannot store NULL.

ALTER TABLE YourTable ALTER COLUMN MSLP_Plus_Value_for_Creation DECIMAL(18,2) NULL;

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item.

Was this reply helpful? Yes No