Unanswered

Incompatible Type. The 'Date' column in the data source you're updating expects a 'Text' type and you're using a 'Time' type

(0) Share

Report

Posted on by jofergalope

hello, i'm having a problem where it says
"Incompatible Type. The 'Date' column in the data source you're updating expects a 'Text' type and you're using a 'Time' type

this is my function:

Collect(
Leak_Reporting2,
{
Date:
Value(date.Selected.Value) +
Time(
Value(HourValue1_1.Selected.Value),
Value(MinuteValue1_1.Selected.Value),
0
),
'WCAV Unit': wcavunit.Text,
'Reported By:': reportedby.Text,
'Type of Leak': typeofleak.Text,
'MRU': mru.Text,
'Complete Adress(provide house number if possible)': completeaddress.Text,
'Nearest Landmark/Meter Number': nearestlandmark.Text,
'Contact Number(if available)': contactnumber.Text,
'CAN(if available)': can.Text,
'Chlorine Test': chlorinetest.Text,
'Remarks': remarks.Text,
}
)

I hope you can help me with this.

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Check this link:

https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-datevalue-timevalue

Collect(
Leak_Reporting2,
{

Date:
DateTimeValue(

Year(date.Selected.Value),

Month(date.Selected.Value),

Day(date.Selected.Value),
Value(HourValue1_1.Selected.Value),
Value(MinuteValue1_1.Selected.Value),
0
),
'WCAV Unit': wcavunit.Text,
'Reported By:': reportedby.Text,
'Type of Leak': typeofleak.Text,
'MRU': mru.Text,
'Complete Adress(provide house number if possible)': completeaddress.Text,
'Nearest Landmark/Meter Number': nearestlandmark.Text,
'Contact Number(if available)': contactnumber.Text,
'CAN(if available)': can.Text,
'Chlorine Test': chlorinetest.Text,
'Remarks': remarks.Text,
}
)

I think that should work

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my LinkedIn!

My website!

My blog!
jofergalope 6 on at

Like
a
(0)

Report
Copy link

Link copied!

still encountering the same error. I tried different approach, but now this is what's happening.

This is my condition now:

Collect(
Leak_Reporting2,
{
Date: date.text,
'WCAV Unit': wcavunit.text,
'Reported By:': reportedby.text,
'Type of Leak': typeofleak.text,
MRU: mru.text,
'Complete Adress(if possible)': completeaddress.text,
'Nearest Landmark/Meter Number': nearestlandmark.text,
'Contact Number(if available)': contactnumber.text,
'CAN(if available)': CAN.text,
'Chlorine Test': chlorine.text,
Remarks: remarks.text
}
)

*chlorinetest,WCAV Unit, and Reported by are all drop down list options
*CAN is just a normal input text
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

And what about this:

Collect(
Leak_Reporting2,
{
Date: DateValue(date.text),
'WCAV Unit': wcavunit.text,
'Reported By:': reportedby.text,
'Type of Leak': typeofleak.text,
MRU: mru.text,
'Complete Adress(if possible)': completeaddress.text,
'Nearest Landmark/Meter Number': nearestlandmark.text,
'Contact Number(if available)': contactnumber.text,
'CAN(if available)': CAN.text,
'Chlorine Test': chlorine.text,
Remarks: remarks.text
}
)

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my LinkedIn!

My website!

My blog!