You’re offline. This is a read only version of the page.
I'm using a batch create/upsert flow created by takolota, but I'm running into an issue where the date is not being passed correctly. I'm simply pulling the date from the excel data source and putting that into the date column to send to my SP list. Other than that, I'm not touching the date anywhere else. In addition, some dates that are more recent, like 4/10/24, are not being passed at all. They are blank.
There were no errors messages displaying after the run, but I dived into the action that appends the error strings, and saw: "Cannot convert a primitive value to the expected type 'Edm.DateTime"" That error message was appended numerous times, but did not say for what record specifically. The rest of the data is preserved and fine, the issue is just the dates rolling back a day and recent ones not importing at all.
I did as the creator said in the video and didn't change anything in the flow other than the SP data, the siteAddress, listName, etc. I can't really provide screenshots as they are on another computer, but some insight into this problem would be helpful.
Here's a link to the video for reference to the flow:
SharePoint Batch Update, Create, & Upsert
Hi @theXenithPoint ,
Could you please share more details? What type is the date column in Excel table? Normally, we use a Date format for this kind of columns and in List rows present in a table action, we select ISO 8601 format:
Besides, please be noted that the date only values are within UTC time zone, so you need to add time zone offset to each date using addHours function or use a Convert time zone action to convert the date into your own time zone before adding it to SharePoint list date and time column.
Best regards,
Share
Report
All responses (
Answers (
237
