Unanswered

HTML table scrambles starting at 19th line item

(0) Share

Report

Posted on by awalker

233

My html table in Powerapps scrambles the date value starting with the 19th line item on. I've tried several online html table testing tools and consulted with a professional to make sure my table wasn't causing the issue. It seems that the corruption happens in Powerapp.

I attached 2 images. One image is the scrambled table. Starting at line 19 all the table contains is the business purpose.

The other image contains the table where the line item returns the text. Starting at the 19th line item the date is returned as a long number value.

The table corrupts the date value at the 19th line item no matter what data is being referenced. It does the same with my time card or maintenance log.

Is there any way to resolve this issue?

Categories:

Building Power Apps

I have the same question (0)

All responses (21)

Answers (0)

Sort by

leyburn19 2,157 on at

Like (0)

Report
Copy link

Link copied!

Do you put the data into text? Can you share the line of code in teh HTML table

" & Text(date,"mm/dd/yyyy") & "

Was this reply helpful? Yes No
awalker 233 on at

Like (0)

Report
Copy link

Link copied!

Here is the html code

Original html.docx

Was this reply helpful? Yes No
leyburn19 2,157 on at

Like (0)

Report
Copy link

Link copied!

Try encasing teh date in text()

& Text(Label4Date,"mm/dd/yyyy") &

Was this reply helpful? Yes No
awalker 233 on at

Like (0)

Report
Copy link

Link copied!

I just tried that but the result is the same. The table still corrupts at the same place in the same way. I can return the date value in text format, but it returns as a long number. I attached a pic in my initial post that shows this.

<td>" & Text(Label4Date) & "</td>

It'll return all dates in the mm/dd/yyyy format until line item 19. Then the date returns as a long number.

Was this reply helpful? Yes No
leyburn19 2,157 on at

Like (0)

Report
Copy link

Link copied!

Check the date in the source data. Are they valid?

Was this reply helpful? Yes No
awalker 233 on at

Like (0)

Report
Copy link

Link copied!

I'm not sure what you mean by "valid", but the data source is a sharepoint list. The Dates are all displaying normal there and the column is set up as a "Date" column. I'm pulling the date into a browse gallery in powerapps that then populates the html table.

The dates display correctly in sharepoint and the browse gallery.

Was this reply helpful? Yes No
leyburn19 2,157 on at

Like (0)

Report
Copy link

Link copied!

Try exporting the list to excel and see if the dates are corrupt in the output

Was this reply helpful? Yes No
leyburn19 2,157 on at

Like (0)

Report
Copy link

Link copied!

I assume they display properly in the Gallery you are using

Was this reply helpful? Yes No
awalker 233 on at

Like (0)

Report
Copy link

Link copied!

I didn't think of that. Clever. I'll have to add that to the troubleshooting toolbox.

The list exports properly to excel. All the dates display as they should.

Was this reply helpful? Yes No
awalker 233 on at

Like (0)

Report
Copy link

Link copied!

Correct, they display properly in the browse gallery

Was this reply helpful? Yes No