cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jonfarmer
Regular Visitor

Excel Data Source Date Field Not Showing in Power App

I have an Excel data source, the table I am using for my Gallery view has a column which is a date. I am trying to showing this on the gallery rows but it just shows as blank. I have tried the following formulas but to no avail. Anyone know where I am going wrong?

 

ThisItem.Date

Text(ThisItem.Date, "dd/MM/yyyy")

 

TIA 

 

Jon

1 ACCEPTED SOLUTION

Accepted Solutions
jonfarmer
Regular Visitor

Hi

 

No worries I have fixed the issue.

 

Many thanks

 

Jon

View solution in original post

3 REPLIES 3
timl
Super User
Super User

Hi @jonfarmer 

Can you confirm what connector you're using to connect to Excel? Are you using the blue OneDrive/OneDrive for Business connector, or are you using the green Excel Online Business connector?

timl_0-1638205803614.png

timl_1-1638205855054.png

 

 

jonfarmer
Regular Visitor

Hi

 

No worries I have fixed the issue.

 

Many thanks

 

Jon

v-xiaochen-msft
Community Support
Community Support

Hi @jonfarmer ,

 

Glad to see you solved the problem.

You could mark yourself to close this case.

 

Best Regards,

Wearsky

 

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,300)