cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LuisRR
Regular Visitor

Object must implement IConvertible.\r\nclientRequestId

Good afternoon I am building an app that records in a sharedpoint list but it does not save the record in the list and sends the following error: 

LuisRR_0-1641512545961.png

 

This is the formula :

 

Patch(
BD_2022,
Defaults(BD_2022),
{
SUBDIRECCIÓN: cbosub,   
FECHA_DEL_OFICIO: txtfchofi .Text,
FECHA_DE_INGRESO: txtfching .Text,
FOLIO: txtFolio1 .Text,
AREA_DE_PROCEDENCIA: cbopro,
REMITENTE: txtrem .Text,
AREA_DESTINATARIA: cbodes,
DESTINATARIO: txtdes .Text,
FECHA_DE_RESPUESTA: txtfchres .Text,
VIGENCIA: cbovige,
ESTATUS_DE_ATENCION_DEL_OFICIO: cbostatus,
RESPONSABLE: txtresp .Text,
ASUNTO: txtasun .Text
}
);

LuisRR_1-1641512735791.png

 

 

 

Helpme Pls.

 

Thank's

10 REPLIES 10
AngeloG
Regular Visitor

Can you post a screenshot of columns type of your list? probably there is a problem with choose colum (AREA_DE_PROCEDENCIA: cbopro or AREA_DESTINATARIA: cbodes etc)

LuisRR
Regular Visitor

Clear! .

This is the screen

LuisRR_0-1641514740665.png

 

AngeloG
Regular Visitor

This is the screen of your app 😁 let me see list of columns of your SharePoint list. PS: Why you use Patch and draw manually every controls instead use Power Apps Form? 

LuisRR
Regular Visitor

LuisRR_0-1641515263986.png

 

AngeloG
Regular Visitor

probably you're passing "control"  instead text properties of you control: try this: 

Patch(
BD_2022,
Defaults(BD_2022),
{
SUBDIRECCIÓN: cbosub,   
FECHA_DEL_OFICIO: txtfchofi.Text,
FECHA_DE_INGRESO: txtfching.Text,
FOLIO: txtFolio1.Text,
AREA_DE_PROCEDENCIA: cbopro.Text,
REMITENTE: txtrem.Text,
AREA_DESTINATARIA: cbodes.Text,
DESTINATARIO: txtdes.Text,
FECHA_DE_RESPUESTA: txtfchres.Text,
VIGENCIA: cbovige.Text,
ESTATUS_DE_ATENCION_DEL_OFICIO: cbostatus,
RESPONSABLE: txtresp Text,
ASUNTO: txtasun.Text
}
);
LuisRR
Regular Visitor

it didn't work

 

all the following are a combo box, from a gallery

SUBDIRECCIÓN: cbosub
AREA_DE_PROCEDENCIA: cbopro
AREA_DESTINATARIA: cbodes
VIGENCIA: cbovige
ESTATUS_DE_ATENCION_DEL_OFICIO: cbostatus

 

 

 

AngeloG
Regular Visitor

Sorry, try something like this:

ComboboxName.Selected.Value
LuisRR
Regular Visitor

It didn't work, but now if you register in the label.Text, not in the choise attached screens....

LuisRR_0-1641602994439.pngLuisRR_1-1641603017139.pngLuisRR_2-1641603061029.pngLuisRR_3-1641603082215.pngLuisRR_4-1641603111975.png

this is the formula

 

Patch(
BD_2022,
Defaults(BD_2022),
{
SUBDIRECCIÓN: cbosub,
FECHA_DEL_OFICIO: txtfchofi .Text,
FECHA_DE_INGRESO: txtfching .Text,
FOLIO: txtFolio1 .Text,
AREA_DE_PROCEDENCIA: cbopro,
REMITENTE: txtrem .Text,
AREA_DESTINATARIA: cbodes,
DESTINATARIO: txtdes .Text,
FECHA_DE_RESPUESTA: txtfchres .Text,
VIGENCIA: cbovige,
ESTATUS_DE_ATENCION_DEL_OFICIO: cbostatus,
RESPONSABLE: txtresp .Text,
ASUNTO: txtasun .Text
}
);
Navigate(
correcto,
CoverRight
);

 

 

Please Help me, I'am very new in PowerApps

AngeloG
Regular Visitor

Because you're passing your combobox control instead text property of combobox control to patch function.

 

atch(
BD_2022,
Defaults(BD_2022),
{
SUBDIRECCIÓN: cbosub,
FECHA_DEL_OFICIO: txtfchofi .Text,
FECHA_DE_INGRESO: txtfching .Text,
FOLIO: txtFolio1 .Text,
AREA_DE_PROCEDENCIA: cbopro,
REMITENTE: txtrem .Text,
AREA_DESTINATARIA: cbodes,
DESTINATARIO: txtdes .Text,
FECHA_DE_RESPUESTA: txtfchres .Text,
VIGENCIA: cbovige,
ESTATUS_DE_ATENCION_DEL_OFICIO: cbostatus,
RESPONSABLE: txtresp .Text,
ASUNTO: txtasun .Text
}
);
Navigate(
correcto,
CoverRight
);

 

These rows, should replaced with:  ComboboxName.Selected.Value

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (1,253)