Answered

Zero values not displaying in Data Tables / Forms / Controls

(0) Share

Report

Posted on by Pierre Andre Joubert

Hi,

Not sure if anyone has come across this, I have done extensive searching and haven't found anything similar.

I have a Whole Number field in CDS and the when the information is displayed in the PowerApp, if the Whole Number field has a Zero '0' it is displayed as blank.

I can set the value in the PowerApp, the zero is pushed to CDS but when displayed directly from the CDS datasource it is displayed as empty, which is obviously very confusing for the user.

Obviously I could create a "display field" in which I can display a zero in my local collection but this is an unnecessary hack when this appears to be a bug in the system. Zero is a number, not a null.

Anyone have any thoughts around this.

Thanks

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @PierreJoubert ,

Could you please share a bit more about your scenario?

Do you mean that the Zero value (0) within the Whole field in your CDS Entity displayed as blank within your app rather than 0?

Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. The screenshot as below:

Please consider take a try to re-generate a new app based on your CDS Entity, then check if the issue is solved.

Also please consider remove the Whole number field from your CDS Entity, then add a new one, then edit your CDS Entity data in Excel (click "Edit data in Excel" option), populate Zero value (0) within the new added Whole Number field, and publish the modification. After that, generate an app based on your CDS Entity, check if the issue has been fixed.

If the issue still exists, as an alternative solution, you could consider take a try with the following workaround:

Within your Gallery, set the Text property of the Label to following:

If( IsBlank(ThisItem.WholeNumberColumn), 0, ThisItem.WholeNumberColumn )

Within your Edit form, set the Default property of the Whole Number field Text Input box to following:

If( IsBlank(ThisItem.WholeNumberColumn), 0, ThisItem.WholeNumberColumn )

Please take a try with above solution, check if the issue is solved.

Best regards,
Pierre Andre Joubert 34 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, This is in a Data Table, not a gallery, and it is a column, not label:

App:

Same data in CDS:
It is not the fault of CDS.
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @PierreJoubert ,

I have also made a test on my side, and don't have the issue that you mentioned. The screenshot as below:

Please consider re-create a new app based on your CDS Entity data source, then check if the issue is solved.

Also please consider take a try to remove the Whole Number field from your CDS Entity, and re-create a new one, then re-create a new app based on your modified CDS Entity, check if the issue has been fixed.

On your side, you could consider save your CDS Entity records into a Collection using the following formula:

ClearCollect(RecordsCollection, YourCDSEntity)

then check if the Zero value (0) within the Actual Quantity field displayed as its original value (0) witin above RecordsCollection. If the Actual Quantity field displayed as Blank witin above RecordsCollection, I think there is something wrong when you retrieve data from your CDS Entity into your app.

In addition, as an alternative solution, please also take a try with the following workaround:

Set the Items property of your Data Table to following:

AddColumns( YourCDSEntity, "QTY", If(IsBlank('Actual Quantity'), 0, 'Actual Quantity') )

then within your Data Table, enable the "QTY" field to display the Whole Number field value.

Best regards,
Verified answer

Pierre Andre Joubert 34 on at

Like
a
(0)

Report
Copy link

Link copied!

Firstly this is a live system, I cannot just delete a field that is in active use.
I am already using local collections as I am using the offline capability extensively.
Whether local or directly from CDS, the column does not display zero values.
Creating a new app is also not a workaround. I have tested this and it is still occurring.

I have created a display field, but this is not a solution.

Nevermind, hacks and workarounds it will have to be.
andy_yee 10 on at

Like
a
(1)

Report
Copy link

Link copied!

I have been running into this same issue recently. I view my collection and see a 0 value in the column (where I calculated with Sum() function across rows in the data source table). But when I display this collection column in a label, all values except the zeros appear.

The workaround solution I found was to use #1 syntax instead of #2.
#1.
RoundDown(Value(ThisItem.CO2e_MT),0)
This works for zeros.

#2.
Text(ThisItem.CO2e_MT,"[$-en-US]#,###")
This does not work for zeros.

Hope this helps.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I had the same issue recently when attempting to create a data table within a powerapp. The solution I had found was to select the field in the table that is showing up blank, the formula bar should read ThisItem,'selectedfield', change to If(IsBlank(ThisItem.'selectedfield'), 0, ThisItem.'selectedvalue')

In my case the selectedvalue was photo count.
I hope this helps.