I am trying to insert records to an Excel data source using Collect function. It first finds the last row in the Excel worksheet (located on the SP) using count rows then it is fetching data from user using Collect function and convert to number using Value() function. The Competency column in the Excel worksheet is in General format, and it is Text format in other Screens as I need to also Edit current records or delete current records using Power Apps to Excel data source. the code is:
Collect(Power_Apps_VA,{Item:Input_Title.Text,TechnicianName:Input_Technician_name.Text, Category:Input_Category.Text, Course:Input_Course.Text, Value(Competency:Input_Competency.Text}).
But I keep getting this error over and over:
Incompatible type. The column in the data source you’re updating expects a 'Text' type and you’re using a 'Number' type
The weird thing is that we can easily use the same code Collect(Power_Apps_VA,{Item:Input_Title.Text,TechnicianName:Input_Technician_name.Text, Category:Input_Category.Text, Course:Input_Course.Text, Value(Competency:Input_Competency.Text}). using SharePoint list as a datasource and the same field is Text in other screens but it never triggers any errors whatsoever!
As the Competency field is something that should be used to do calculations and aggregations I need this field to convert to data when sending data to the datasource.
Many thanks for the help in advance!
