I have a canvas app that connect to an Excel table shared on OneDrive that contains a Date/Time field that comes from an MS Form. When I try to display this column in a DataTable of a screen, it never shows any data even though there is data in the Excel table.
Solved! Go to Solution.
Based on the issue that you mentioned, do you want to display Date/Time field in the DataTable ？
Could you please tell me that if only the Date/Time field in unable to display or all the fields are unable to see?
Have you connected the OneDriveForBusiness to your App?
I have a test on my side, please take a try as below.
1). Click the "New Form" tab in MS Form page and name the form
2). Click the "Add New" in Questions tab to add columns
3). Click the "Preview" to add response, submit
4). Click the "open in excel", and then you will get a same table in the Excel
5). Move the exported excel table into your OneDriveForBusiness
If all the fields in the excel table are unable to display in the DataTable, please make sure that you have save your exported excel table on OneDrive.
Hope it could help you.
When I try the test above, all columns show up except the data/time columns. Same as my app. Note that I am using the automatically generated fields by MS Forms, Start time and Completion time, not questions in the Form that are of type Date/Time.
Do you mean that you could not display the automatically generated field 'Completion time' in PowerApps?
Could you please share a bit more about your scenario?
I have a test and the situation is confirmed on my side that the automatically generated field 'Completion time' displays well in my Power Apps app.
Here is my exported excel table shared on OneDriveForBusiness.
And here is the available fields I can add to the DataTable:
Could you please change another browser to try again.
If the above could not solve your problem, please consider contacting our Support Team.
Hope it could help you.
Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.
Your chance to join an engaging competition of Power Platform enthusiasts.
The Super User program for 2022 - Season 2 has kicked off!
Attend in person or online, there are incredible conferences and events happening all throughout the month of September.