Data in Galleries

[JE_Forero]

Good morning group, I have the following problem that I appreciate your advice to solve it

1-. My data source is a list in sharepoint - tbl_102_InventarioTICS

2-. On the scrActa screen in the OnVisible property I create a blank collection like so:

ClearCollect(colAgregarActivosActa01;Table(

{

    ActaNumero:"";

    FechaMovimiento:"";

    TipoMovimiento:"";

    TipoActivo:"";

    Proveedor:"";

    ValorActivo:"";

    Caracteristicas:"";

    Observaciones:"";

}

));;

Clear(colAgregarActivosActa01)

3-. Then, I have a gallery glrIngreso that connects to the data source tbl_102_InventarioTICS and I have the btnAdd button inside the gallery item with the following:

Collect(colAgregarActivosActa01;

{

    ActaNumero:lblNumeroActa.Text;

    FechaMovimiento:dpkFechaActa.SelectedDate;

    TipoMovimiento:cmbTipoMovimientoNuevo.Selected.Result;

    TipoActivo:ThisItem.TipoActivo;

    Proveedor:ThisItem.Proveedor;

    ValorActivo:"";

    Caracteristicas:ThisItem.Caracteristicas;

    Observaciones:txbNotasObservaciones.Text;

    Disponible:lblDisponibleSiNoActa.Text

}

)

This add button feeds the collection that I create blank in the OnVisible property of the screen colAgregarActivosActa01 and As you can see, I have some fields that are fed by some text or date labels outside the glrIngreso gallery and others with the ThisItem property of data from The galery.

4-. The problem: I have two problems. If I leave these two values at "" no errors are observed.

4.1-.     FechaMovimiento:dpkFechaActa.SelectedDate;

The error: Incompatible type, the collection cannot contain values of this type, so I don't know how to pass the date value

4.2-.     ValorActivo:"";

If I put ValorActivo:ThisItem.ValorActivo

Incompatible type, the collection cannot contain values of this type, this value is numeric

How could I pass these two values to my collection, one from a date element outside the gallery and the other the numeric value found inside the gallery.

Thank you for your support

Thank you

[cha_cha · Accepted solution]

Hello @JE_Forero 

I believe this problem started because you initiated the value of the properties to a string.

Two options you can do:

Option A: JUST DON'T INITIALIZE IT. Your OnVisible code should be just like that OR

Clear(colAgregarActivosActa01)

Option B: Initiate with the right type:

ClearCollect(colAgregarActivosActa01;Table(
{
    ActaNumero:"";
    FechaMovimiento:Today();
    TipoMovimiento:"";
    TipoActivo:"";
    Proveedor:"";
    ValorActivo:false;
    Caracteristicas:"";
    Observaciones:"";
}
)

---

✔️	Just in case my response helped you solve your problem, please mark/accept this as a SOLUTION.  This helps community members if they experience a similar issue in the future.

🔗	🕸bistek.space  🐦 @cha_bistek  📺 @BisTekSpace

[Drrickryp · Accepted solution]

@JE_Forero 

Or use your list to create the blank collection.  That way, the collection schema will be identical to the list and allow you to easily add or modify the records using your collection. 

 ClearCollect(colAgregarActivosActa01, Defaults(tbl_102_InventarioTICS))

[JE_FT]

Hello Cha_Cha
Thank you very much for your help, it works perfect

[JE_FT]

Hello drrickryp
Thank you very much for your help, this alternative has also worked for me

[JE_Forero]

Hello Cha_Cha
Thank you very much for your help, it works perfect