Answered

Incompatible Type: The column in data source you're updating expects a 'Number' type and you're using a 'Text' type.

(0) Share

Report

Posted on by DJfinley

I'm having trouble with the coding on my PowerApp and need help. My data source is a SharePoint List. How do I fix an Incompatible Type error? I'm in the process of coding for the ADD button on a form. I'm attempting to use the collect function to make this happen. However, I continue to receive an error that tells me the "LastFour" column in data source you're updating expects a 'Number" type and you're using a 'Text' type. I'm not sure what ending I'm needing to make this work (e.g. .Text, .Selected , etc.) I've been searching and have come up blank. Is there a way to get this to happen. The "LastFour" column is my only column from my SharePoint List whose category is Number. I've attached a screenshot of the Collect Function I've created.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

mmollet 3,187 on at

Like
a
(3)

Report
Copy link

Link copied!

Wrap that in a Value() call. So Value(LastFour) and see if that fixes the error. This is essentially typecasting the text value into a number value.

Was this reply helpful? Yes No
Jessica_Okezie1 2 on at

Like
a
(0)

Report
Copy link

Link copied!

I’m having an issue with this Code.
incompatible Type. The ‘OrdeID’ Column in the data source you’re updating expects a Text Type and you’re using a Number Type.
I went to my SharePoint List and corrected the column to use Text Type and it hasn’t corrected itself.
how do I go about it?

Was this reply helpful? Yes No
jofergalope 6 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No