Share
ReportI'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
All responses (
Answers (
342
