Table Name failed : {"error":{"code"-2147015414",message":"Prepare statement failed : SQL Logic error (1) - table new_tableName had no column named new_dateofbirth", "stacktrace":"unkonwn","innererror": {"code": "2147015414",message : " Prepare statement failed : SQL Logic error (1) - table new_tableName had no column named new_dateofbirth"}}}
Patch(
'TABLE NAME',
Defaults('TABLE NAME'),
{
'First Name': FName.Value,
'Last Name': LName.Value,
'Email': Email.Value,
'Date of Birth': If(
!IsBlank(DOB.SelectedDate),
DateValue(DOB.SelectedDate),Blank()
),
'Date': If(
!IsBlank(Date.SelectedDate),
DateValue(Date.SelectedDate),Blank()
),
'Mobile Phone': phone.Value,
'Date1': If(
!IsBlank(Date1.SelectedDate),
DateValue(Date1.SelectedDate),Blank()
),
'Period': Period.Selected.Value,
Name:FName.Value
}
)
Am using above code from Canvas App, when i run from Browser it is working as expected but if i run from mobile app we are getting above mentioned error.
I tried Uninstalling PowerApps and Reinstalled and cleared Cache too. It seems sometimes its working in IPHONE
DOB is DATETIME field but we are using DATE Values only
i changed to new_dateofbirth and tried, DateTimeValue also i tried.
Its Offline Capability Enabled, but we started testing with OnLine and struck here
All Date Fields are Mandatory in PowerApps
