web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Excel Table Column wit...
Power Automate
Unanswered

Excel Table Column with dates seen as "null"

(0) ShareShare
ReportReport
Posted on by 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:
I have the same question (0)
  • mahoneypat Profile Picture
    1,720 on at
    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

     

  • EG-31080115-0 Profile Picture
    118 on at
    Re: Excel Table Column with dates seen as "null"

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

  • Verified answer
    EG-31080115-0 Profile Picture
    118 on at
    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.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 497 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 477 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 242

Last 30 days Overall leaderboard