I am building a powerapp which pulls the data from MS forms (which is saved as an excel spreadsheet in teams)
This is working well with one exception I can't pull in the date from the form due to it's formatting
Forms automatically saves the date of each submission in this format
m/d/yy h:mm:ss
My thinking is then to format the datacard value accordingly but it still comes up blank.
Text(ThisItem.calldate,"d/m/yy h:mm:ss")
any ideas how to pull this info in?
