Skip to main content

Notifications

Power Automate - Using Flows
Unanswered

Excel List Rows in Table - Custom Format Cells Returned as Serial Numbers Converted to Dates

(0) ShareShare
ReportReport
Posted on by 21

Scenario: We receive an emailed spreadsheet from a large vendor containing purchase order data. A Flow picks up the spreadsheet, takes the row data, and adds it to an internal system. Several columns have custom cell formatting.

 

Issue: Around January 26, the Flow started failing when working with several of the columns of data (quantities or currency amounts). The issue is that the fields are interpreted as serial numbers and converted to dates.

 

Example: A cell with value 4 is returned as 1900-01-03T00:00:00.000Z (Custom cell format for the column is [$-en-US,1]#,##0;-#,##0)

 

Nothing has changed with the formatting of the columns and cells of the affected columns. Comparing versions of the spreadsheet pre and post-issue, the formatting is the same. The DateTime Format of the 'List rows present in a table' action is set to 'ISO 8601' and has not changed.

 

Has anyone else experienced this issue? We found setting the cell format to 'General' fixes the issue (quantity and currency values are read as numbers and dollar amounts, respectively). However, I have not found that you can change cell formatting in a cloud Flow. Since the spreadsheet comes from a large vendor, changing their side of the process is not an option (for example, setting all columns to general formatting).

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard

Featured topics

Restore a deleted flow