Power Automate started importing dates from excel as dates instead of as integers - Stack Overflow

admin管理员组

文章数量:1345295

I have a Power Automate flow set up for one of my Excel workbooks. Once daily it parses through a table of tasks and sends emails to each person with outstanding tasks, comprising of the 'Task' and the 'Due Date' column for each task that person has. This flow worked perfectly for about a month, now it seems to have stopped importing the data in the 'Due Date' column as an integer and instead is importing the data as a date. Here are two pictures showing the raw input data to the Create HTML Table action, before and after the change occurred.

The 'Due Date' column is formatted as Short Date. The cells are filled with "=IF(ISBLANK(Tasks!B131), "", Tasks!B131)" formulas, copying the data from a column in a separate tab if it is populated and staying blank if it isn't. That column is also formatted as Short Date. I checked the version history and nothing about the formatting of these columns changed from working to not working. Why would Power Automate be taking this data in incorrectly and how can I change it back?

A few more details. In the Excel document, the dates show as DD/MM/YYYY when formatted as Short Date. If I change the format of the column to General the flow runs correctly and the dates show in the emails as YYYY-MM-DD format, but they are displayed in the Excel document as integers whereas I want them to display as dates. Here is the entire flow: The code for Filter Array is:

{
  "type": "Query",
  "inputs": {
    "from": "@outputs('List_rows_present_in_a_table')?['body/value']",
    "where": "@equals(item()?['Email'],items('Apply_to_each'))"
  }
}

The code for Create HTML Table is:

{
  "type": "Table",
  "inputs": {
    "from": "@body('Filter_array')",
    "format": "HTML",
    "columns": [
      {
        "header": "Description",
        "value": "@item()?['Task']"
      },
      {
        "header": "Due Date (Conv)",
        "value": "@if(empty(item()?['Due Date']),null,addDays('1899-12-30',int(item()?['Due Date']),'yyyy-MM-dd'))"
      }
    ]
  },
  "runAfter": {
    "Filter_array": [
      "Succeeded"
    ]
  }
}

I have tried reformatting the columns as dates and running the flow again, expecting the flow to correctly import the date data, but nothing changed.

本文标签： Power Automate started importing dates from excel as dates instead of as integersStack Overflow