I am using an excel table as a datasource for my powerapp, this has over 91 columns each of which will have a date entered into the rows in the format of R2023-04-28 or C28/04/2023. All of the columns have pulled through as text fields which is correct because of the leading R or C, but one in particular has pulled through as a datetime randomly and is now giving me errors such as:
and an error in my patch function behind the submit button because im using datacardvalue.text and its not pulling as text.
In the published version of my app it works fine, but there seems to of been a change made that has broken it, and i've tried to restore the working version but it isn't working.
See view when trying to add the field:
HR PO 004 is showing as date but all the rest - PR PF 224 for example are text fields.
How can i change it back to a text field? because I'm using excel as a datasource i'm not sure what determines what kind of value it is?
