Unanswered

Set a Number and a Datetime field to Blank() inside the Update property insdie a form is not working

(0) Share

Report

Posted on by johnjohn123

3,506

We have a Form and inside the form we have 2 fields; Number field + DateTime field which connect to a SharePoint list, now inside the 2 data-cards i provided these 2 formulas to either submit the selected value or submit Blank()

If(Value(NumberOfInstallments.Selected.Value) >= 4,DataCardValue70.SelectedDate,Blank())

If(Value(NumberOfInstallments.Selected.Value) >= 4,Value(DataCardValue69.Text),Blank())

now even if this condition is false (Value(NumberOfInstallments.Selected.Value) >= 4) the value inside SharePoint will not be null... any advice? seems the Update property does not like the Blank() value? to submit the form i am using the buil-in function SubmitForm()..

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Sundeep_Malik 6,484 on at

Like (1)

Report

Hey @johnjohn123

It seems the issue might be related to the Update property of the data cards in the form. When you use Blank() in the Update property, it may not correctly update the SharePoint list with a blank value.

Instead of using Blank() , you can use an empty string "" to set the field value to empty. This should work with the Update property and correctly update the SharePoint list with blank values when the condition is false.

Modify the formulas in the Update property of the data cards as follows:

For the DateTime field:

If(Value(NumberOfInstallments.Selected.Value) >= 4, DataCardValue70.SelectedDate, "")

For the Number field:

If(Value(NumberOfInstallments.Selected.Value) >= 4, Value(DataCardValue69.Text), "")

i hope this helps 🙂

Was this reply helpful? Yes No
johnjohn123 3,506 on at

Like (0)

Report

@Sundeep_Malik thanks for the update, i tried your formula but still the value will never be set to "" and the value will stay the same

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (1)

Report

@johnjohn123

Ok before I directly gave you an expression. This time I will try it on my end.

Before trying I want to ask this Number of Installment value is coming from where. Is it another drop-down in the same form or is it coming from somewhere else?

Was this reply helpful? Yes No
johnjohn123 3,506 on at

Like (0)

Report

@Sundeep_Malik it is a combo-box representing a SharePoint choice field and it is inside the same form and get submitted with the form.. thanks

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @johnjohn123,

To update a Number field and a Date field with null value, please modift your formula as below:

If(Value(NumberOfInstallments.Selected.Value) >= 4,DataCardValue70.SelectedDate,DateValue("")) If(Value(NumberOfInstallments.Selected.Value) >= 4,Value(DataCardValue69.Text),Value(""))

Was this reply helpful? Yes No
johnjohn123 3,506 on at

Like (0)

Report

@v-qiaqi-msft i tried your formulas but still they will not set the value to null inside sharepoint,

Was this reply helpful? Yes No
johnjohn123 3,506 on at

Like (0)

Report

@v-qiaqi-msft @Sundeep_Malik

Also I also have this feature turned off and i do not want to turn it on at this stage becuase we might face extra error

Was this reply helpful? Yes No
bangnoy 2 on at

Like (0)

Report

If you used Sharepoint List as your database table, maybe you can check it first.
at column setting, choose Edit > Default Value change to None.

And set your Datepicker DefaultDate property in PowerApps to Blank()

Hope this answer your question.

Was this reply helpful? Yes No