cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
a10703ant
Helper I
Helper I

Excell Table doesnt show hour/time duration column

Hi guys,

 

I hope you are doing well,

 

I have problem to import my excell table to powerapps.

 

a10703ant_0-1643729288674.png

a10703ant_1-1643729312779.png

I have two collumns with time format and other with custom (h:mm:ss) but when i connect the table on powerapps the collumn is empty...

 

a10703ant_2-1643729471713.png

Someone can help me please?

 

Thank you for your time

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

Hi @a10703ant :

I've made a test but it worked well on my side:

vbofengmsft_0-1643960166167.png

vbofengmsft_1-1643960185493.png

Maybe you could try to set the column's Text property to:

ThisItem.Time

Or

Text(ThisItem.Time,DateTimeFormat.ShortTime)

vbofengmsft_2-1643960265155.png

If the problem still exists ,I suggest you create a support ticket for professional assistance following the below procedure. 

Get Help + Support - Power Platform | Microsoft Docs 

Best Regards,

Bof

 

 

 

View solution in original post

2 REPLIES 2
a10703ant
Helper I
Helper I

I try to change the format but keeps the same problem 😕

v-bofeng-msft
Community Support
Community Support

Hi @a10703ant :

I've made a test but it worked well on my side:

vbofengmsft_0-1643960166167.png

vbofengmsft_1-1643960185493.png

Maybe you could try to set the column's Text property to:

ThisItem.Time

Or

Text(ThisItem.Time,DateTimeFormat.ShortTime)

vbofengmsft_2-1643960265155.png

If the problem still exists ,I suggest you create a support ticket for professional assistance following the below procedure. 

Get Help + Support - Power Platform | Microsoft Docs 

Best Regards,

Bof

 

 

 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,677)