Good morning! I'm developing an app that sends forms to Dataverse. Since this application will be used in remote locations, I need to have a local form saving option. For this purpose, I created the collection "colSMUTF02" where, in case of no connection, the form would be saved locally.
Collect(colSMUTF02, {
crf6b_trabajoareaobservada: DataCardValue12.Text,
crf6b_legajon: Value(DataCardValue9.Text),
crf6b_nombrecompleto: DataCardValue13.Text,
crf6b_descripciondelriesgoobservado: DataCardValue5.Text,
createdon: Now(),
crf6b_seccion: DataCardValue11.Selected,
crf6b_detalleobservacioncorreccion: DataCardValue7.Selected.Value,
crf6b_detalleobservacionaccion: DataCardValue6.Text,
crf6b_accionespropuestas: DataCardValue3.Text,
crf6b_comentariosjefecoordinado: DataCardValue4.Text,
crf6b_lat: Location.Latitude,
crf6b_long: Location.Longitude,
crf6b_fechacreacionoffline: Now()
})
On my second screen, I have a gallery that displays each entry from that collection with a button to Patch that entry to my Dataverse table, which works correctly. My problem arises when I try to Patch multiple entries at the same time. I tried using ForAll for each entry, but it gives me the following error: "The specified column does not exist." I double-checked the logical name of the Dataverse column, and it matches correctly. Likewise, the Patch for a single record works correctly.
If(Connection.Connected,
Patch('SM UT F 02', Defaults('SM UT F 02'),
{
'Trabajo / Area Observada': ThisItem.'Trabajo / Area Observada',
'Legajo N°': ThisItem.'Legajo N°',
Usuario: ThisItem.Usuario,
Seccion: LookUp(Secciones, 'Seccion Descripcion' = ThisItem.crf6b_seccion.'Seccion Descripcion'),
'Descripcion Del Riesgo Observado': ThisItem.'Descripcion Del Riesgo Observado',
'Detalle Observacion Correccion': If(Text(ThisItem.'Detalle Observacion Correccion') = "Si", true,
Text(ThisItem.'Detalle Observacion Correccion') = "No", false),
'Detalle Observacion Accion': ThisItem.'Detalle Observacion Accion',
'Acciones Propuestas': ThisItem.'Acciones Propuestas',
'Comentarios Jefe Coordinado': ThisItem.'Comentarios Jefe Coordinado',
Lat: ThisItem.Lat,
Long: ThisItem.Long,
'Fecha Creacion Offline': ThisItem.'Fecha Creacion Offline'
}
)
);
If(IsEmpty(Errors('SM UT F 02')),
Remove(colSMUTF02, ThisItem);
SaveData(colSMUTF02, "colSMUTF02ParaCargar")
)
);
However, when I try to Patch the entire collection or a single record, that's when the error occurs. I have attached the images for reference.
Thanks in advance to everyone!
