Date/Time data not showing up

(0) Share

Report

Posted on by mhenderlight

155

Hi,

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.

Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

v-qiaqi@microsoft.com on at

Like (0)

Report

Hi@mhenderlight,

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.

Regards,

Qi

Was this reply helpful? Yes No
mhenderlight 155 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report

Hi@mhenderlight,

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.

Regards,

Qi

Was this reply helpful? Yes No
Verified answer

mhenderlight 155 on at

Like (0)

Report

Yes, you understand the scenario correctly. I just bailed on Excel and moved to SharePoint lists and everything works fine now.

Was this reply helpful? Yes No