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

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Srini007 3,471 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @psrini20,

I have a simple demo for your reference:

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

And this is my excel table:

Was this reply helpful? Yes No
psrini20 14 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No