Time format issue when i add data from excel to HTML table

(0) Share

Report

Posted on by psrini20

Hi,

Good day!

I created an HTML table from excel. In output time format was wrong reflected in the integer format and one of the text fields showed null value. Could you please help me to sort out this issue?
Excel Input:

HTML Output

All responses (3)

Answers (1)

psrini20 14 on at

Like (0)

Report

Re: Time format issue when i add data from excel to HTML table

Thanks, for your support.
I have another question. Bullet points in my Excel table do not appear one after the other. In the HTML table, everything is on a single line. How do I obtain that?
Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Re: Time format issue when i add data from excel to HTML table

Hi @psrini20,

I have a simple demo for your reference:

formatDateTime(item()?['StartTime'],'hh:mm tt')

And this is my excel table:
Srinivas Kadamati 3,068 Super User 2025 Season 1 on at

Like (0)

Report

Re: Time format issue when i add data from excel to HTML table

Hi @psrini20

Can you share a screenshot of your workflow expanded and if any expression explain

So that it will easy for debugging and understand your issue

If you find this reply helpful, please consider giving it a LIKE AND

If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION