News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Create an Item in Shar...

Power Automate - Building Flows

Answered

Create an Item in SharePoint- Error with the date column

(0) Share

Report

Report

Posted on by ArshUser

78

Hi,

I am trying to Create an Item in SP list by adding excel (table) rows in it. I am facing an error with the date column:

SP list column "DateofJoining" is of the type "Date and Time" with only Date values.

I tried different custom formats for my Excel Date Column but still getting the same error.

Any solution for this?

Thanks in Advance!

Categories:

Business Process Flows

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

fchopo 7,968 Super User 2025 Season 1 on at

Like (0)

Report

Re: Create an Item in SharePoint- Error with the date column

Hi @ArshUser

When getting the values from Excel, be sure that date come in ISO-8601 format, because if not they come as an integer value:

ISO8601 format works with "yyyy-MM-ddThh:mm" format.

Hope it helps!
Ferran

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 497 Super User 2025 Season 1

#2

David_MA 436 Super User 2025 Season 1

#3

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans