Power Platform Community Forum Thread Details

Hi Everyone,

I have recently started with PowerApps and I have a problem which I was not able to solve even with lot of tries (-_-).

Exactly as mentioned in the subject, Date is not showing up in PowerApps from Excel (Online Business)!

I started with blank canvas, connected the data (Excel Online), added the form (both display/edit), selected the fields which I wanted to show/edit, changed the property item to browsegallery1.Selected, now all the data is now visible but not dates.

I think data connection is correct since rest of data is visible.

Here is what I have tried till now...

1. All different date formats in the source excel file. (Short date, Long Date, dd/mm/yyyy etc etc.). Result > No data in dates.

2. Tried to change the formats in PowerApps, Eg. (text(thisitem.date,"dd/mmm/yy")). Result > Nope

3. While changing formats, tried reconnecting the excel to PowerApps

4. Updating default properties

I was not able to find any solution here as well. So maybe this can be solved once and for all.

Screenshots:

1. Excel online datasource screenshot

Excel Online Source Table. Refer Start Date and End Date columns.

2. PowerApps screenshot. As you can see for other fields correct data is visile but for START DATE and END DATE field default data and no data is shown. One thing to notice is when I added the field of data in forms it created the date field in this format which I think is probably DD/MM/YYYY hh:mm. This is strange because the format type in the source excel was date.

PowerApps screenshot. As you can see for other fields correct data is visile but for START DATE and END DATE field default data and no data is shown. One thing to notice is when I added the field of data in forms it created the date field in this format which I think is probably DD/MM/YYYY hh:mm. This is strange because the format type in the source excel was date.