Server Response: Object must implement Iconvertible

[dyee4614]

I'm not sure why I'm getting this error.  Here are my data sources:

- SQL Server

- Sharepoint List

- Excel lookup

The SQL Server is all used for lookups.  The lookups work.  The sharepoint list was originally from an excel sheet.  It didn't look like there was any issues with the upload.  The formula is just a simple Patch.  What is causing this error?

Edit: I saved and closed my app.  I refreshed the data.  Problem remained.

"Server Response: Object must implement Iconvertible"

Patch('Workers Comp', Defaults('Workers Comp'),
{
EENAME: Name5.Text,
EENO: Value(No5.Text),
PHONE: Phone5.Text,
DOI: DOI5.SelectedDate,
YEAR: Year(DOI5.SelectedDate),
CORRECTIVEACTION: CorrectiveAction5.Selected.Value,
CLAIMREPORTED: ClaimReported5,
STATUS: Status5.Selected.Value,
CLOSEDATE: CloseDate5.SelectedDate,
H2A: H2A5.Text,
DOH: DoH5.Text,
DOB: DoB5.Text,
DORH: DoRH5.Text,
CREW: Crew5.Text,
CLASSCODE: ClassCode5.Text,
NOTE: Notes5.Text})

[v-siky-msft · Accepted solution]

Hi @dyee4614 ,

What is 'ClaimReported5'? 

I would recommend you to reduce fields in Patch function step by step to check which fields cause the issue.

Sik

[dyee4614]

That was it!  Thank you!

[v-siky-msft]

Hi @dyee4614 

So, the issue is caused by  'ClaimReported5' field, right?

Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Sik

[dyee4614]

Sorry!  I thought I clicked it.  Thank you!