Problem with ClearCollect changing date fields to text

[themistoklis]

Hello All,

I connect to a Dataverse table to retrieve the data and the datatype of all fields are identified correctly to Powerapps.

When I create a new collection (because I join 2 Dataverse tables) then the datatypes of all fields are converted to text (including the date fields).

ClearCollect(ANPR_joined_dataset, 
   AddColumns('ANPR - LiveFeeds NEW',
       "Full_Name_or_Service", LookUp('ANPR - Vehicle Registration Plate Mappings', Car_Plate_No_No_Spaces='ANPR - LiveFeeds NEW'[@cre34_carplate], Full_Name_or_Service)
   )
);

The change of date fields to text causes additional problems to my powerapps report as I cannot query the data.

How can I prevent this from happening?

Also it doesnt give me the option to change the control type from Text Column to Datetime column

Is there an efficient way to change the text date column to date column?

I used various formulas for the conversion from Text to Date (or Datetime) but when I query the data using the new date column it never returns any results.

It seems that it doesnt understand the format of the new date column.

Thank you

[v-qiaqi-msft]

Hi @themistoklis,

I have made a test and the situation is confirmed on my side.

Firstly, we could not connect a collection to an Edit form.

Secondly, we could keep the date time type when we collect data from Dateverse table. Here I collect Pet2S table into ColPet and the PaymentDate is a DateTime type in the Dateverse table. You could find that the Label display data in data time format.

[themistoklis]

Hello @v-qiaqi-msft ,

Thank you for the reply,

I would like some clarifications regarding your answer.

When you say you confirmed the situation, do you mean that the join of 2 Dataverse tables return text fields only?

[v-qiaqi-msft]

Hi @themistoklis,

What do you mean by that the joined Dateverse table returning text fields only? 

Unless you use some function like Text() to format the date time columns, a Date and Time column from Dataverse table will keep its column type in a collection.

Additional, how you populate the form item property with? You could only connect the form with data source from with data based instead of a temporary where you have Text columns storing date time value.