Power Automate DateTime Format Error

[anthonjhnon1]

Ok I'm having some sort of unsolvable issue with it comes to my datetime columns. I've tried everything I can think of and nothings working. What's even more frustrating is that I've done this before and it worked in the past. I still have the original automation and I even tried mimicking the entire automation which isn't much. 

I have a manual trigger, Excel: list rows present in table, and SharePoint: Create Item. I've tried with ISO 8601 format and without with data manipulations in a compose statement to verify the values. Even then it says something is wrong. I even tried chat GPT, searched all over the internet and nothing is helping.

Error Message

The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/Last_Worked' is required to be of type 'String/date-time'. The runtime value '""' to be converted doesn't have the expected format 'String/date-time'.

With ISO 8601, I even tried this using an 'or' instead of a nested if.

if(
empty(item()?['Last Worked']),
null,
if(
equals(item()?['Last Worked'], ''),
null,
concat(
substring(item()?['Last Worked'], 0, 10),
'T',
substring(item()?['Last Worked'], 11, 8),
'Z'
)
)
)

Without ISO 8601, I even tried 'null' instead of '1899-12-30'

addSeconds(
addDays('1899-12-30', int(first(split(outputs('LastWorked'), '.')))),
int(
formatNumber(
Add(
mul(
float(concat('0.', last(split(outputs('LastWorked'), '.')))),
86400
)
,1
),
'#0')
)
)

Please help me, this is driving me crazy knowing it worked before.

[anthonjhnon1]

I know its weird because I got this to work before with a different snapshot of the data I'm trying to upload.

[anthonjhnon1]

I gave up and just turned my date columns into strings. I'm still waiting on the data to upload. Been 10 mins now and no error messages but I'm not seeing any data being populated yet. Normally I would get the error message in under 1 minute. 

If this doesn't work, does anyone know of another method of uploading Excel Data to a SharePoint list?

[anthonjhnon1 · Accepted solution]

OMG, I finally got it working. The error had nothing to do with what it was telling me the error was. I'm so angry that it wasn't giving me the right error message. The issue was coming from the fact that I told SharePoint list not to duplicate the Project ID field. However, we have tons of blanks. I need to let Power Apps control not creating duplicates.

I have literally been working on this none stop since Thursday.

I only caught this because I got the duplicate error message when I changed everything to a string.