Unanswered

Excel Table Column with dates seen as "null"

(0) Share

Report

Posted on by EG-31080115-0

118

I have a flow to update or create items in SP List based on Excel Table. One of the columns in my table, Column H, contains dates (eg 28/Jan/2024). My flow runs successfully but no values from Column H are populated to my List. When I review the completed flow it shows on Inputs that Column H is "null". I've tried delete and recreating the column in my SP List and rebuilding flow from scratch. Neither attempt changed the "null" interpretation of Column H.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

mahoneypat 1,720 on at

Like (0)

Report

Re: Excel Table Column with dates seen as "null"

Is your SharePoint column a Date column? If so, your Excel is likely text and you'll need to convert it to DateTime to write it to SharePoint. Or you can convert your SharePoint column to a text column.
Regards,
Pat

Was this reply helpful? Yes No
EG-31080115-0 118 on at

Like (0)

Report

Re: Excel Table Column with dates seen as "null"

The SP List column is text. The Excel column is Custom format.

Was this reply helpful? Yes No
Verified answer

EG-31080115-0 118 on at

Like (0)

Report

Re: Excel Table Column with dates seen as "null"

Turns out my problem was in the column name in my Excel table which contained a "/". The JSON language used by Power Automate also uses "/" as a delimiter. So, when it pulled in column name it was adding and extra space for the "/" in the name and causing my Flow to fail. Once I replaced the "/" with an underscore in the column name the Flow worked perfectly.

Was this reply helpful? Yes No