Solved: Re: NULL value in gallery items causing Errors?

Jasmin_Sch · ‎04-19-2021

Hi!

I am facing hundres of errors in my app saying:

Value can not be converted into number because value is an empty string

OR

An empty text can not be converted into a number.

My situation:

I created two apps (repeating table via gallery). One to create a work package and one edit a existing work package.

I had the same errors on my app to create a new work package and I replaced all values like this:

From this: GJ24Q3APV: Value('Input GJ24Q3'.Text)

To this:

GJ24Q3APV: IfError(

Value('Input GJ24Q3'.Text);

Blank()

And it worked.

In my edit app I display all submitted items via a gallery. And a lot of items do show a “0”. The default property is just: ThisItem.Name of Column

My this cause the problem and how can I solve it?

Thank you very much!

Jasmin_Sch · ‎04-23-2021

I found a solution. I patched the values into my collection (in the onchange property) of every item. And used my collection items (line....) for my sum functions instead of my text inputs....no errors 😉

thank you!

View solution in original post

Jasmin_Sch · ‎04-19-2021

I think I a halfway solution.

To create a collection I set the number columns like LineGJ21:Blank()

instead of LineGJ21:0

But it still shows an error with my sum function. Basically I want to sum all items of my gallery which are not blank.

This is my current function:

Sum('Gallery Neues Arbeitspaket Tätigkeit'.AllItems;'Input GJ21Q3')

v-albai-msft · ‎04-22-2021

Hi @Jasmin_Sch ,

What is the error message for your sum function?

Is Input GJ21Q3 in your gallery a Textinput control?

If someone enter a value manually in the gallery for one item, will you update this value into your collection?

Per my test, no matter creating a collection using "LineGJ21:Blank()" or "LineGJ21:0", Sum function both works well.

Also, you mentioned in your first reply, that “in your edit app, a lot of items do show “0” inside gallery”. I would suggest you check your first creating new package app, make sure if you have submitted new package successfully.

Please provide your detailed steps so that I can have a test on my side with your steps. It’s better if you can also provide some screenshots.

Best regards,

Allen

Jasmin_Sch · ‎04-22-2021

@v-albai-msft Thank you!!

To create a collection for my repeating table

NewForm('Form Neu');;

ClearCollect(

Tätigkeiten;ForAll(Sequence(10);

{

LineTitelTätigkeit: "Titel Tätigkeit";

LineProjekttyp: "R&D";

LinePrio: "Prio 1";

LineStatus: "Offen";

LineWunschressource: glbEmptyPerson;

LineAbteilungWunschressource: "";

LineAbteilung: "";

LineGJ21Q1APV:"0";LineGJ21Q2APV:"0";

LineGJ21Q3APV: "0";

LineGJ21Q4APV: "0";

LineGJ22Q1APV: "0";

LineGJ22Q2APV: "0";

LineGJ22Q3APV: "0";

LineGJ22Q4APV: "0";

LineGJ23Q1APV: "0";

LineGJ23Q2APV: "0";

LineGJ23Q3APV: "0";

LineGJ23Q4APV: "0";

LineGJ24Q1APV: "0";

LineGJ24Q2APV: "0";

LineGJ24Q3APV: "0";

LineGJ24Q4APV: "0";

LineGJ25Q1APV: "0";

LineGJ25Q2APV: "0";

LineGJ25Q3APV: "0";

LineGJ25Q4APV: "0";

LineGJ26Q1APV: "0";

LineGJ26Q2APV: "0";

LineGJ26Q3APV: "0";

LineGJ26Q4APV: "0"

}

))

Gallery (Items Property: Tätigkeiten) inside a container

+ Button to add rows:

Collect(

Tätigkeiten;

ForAll(

Sequence(2);

{