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})
Sorry! I thought I clicked it. Thank you!
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
That was it! Thank you!
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
WarrenBelz
146,763
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional