Unanswered

Some dates causing Excel to SharePoint list to fail

(0) Share

Report

Posted on by probey82

I want to preface by saying I've read numerous threads regarding similar issues and I'm aware of many of the common fixes.

I have a flow to upload an Excel file to a SharePoint list. I have the DateTime Format in List Rows Present in a Table set to ISO 8601. There is a Compose action for each date which is used in the Create Item action:

if(empty(outputs('Compose_2')), null, outputs('Compose_2'))

The flow handles most of the dates as expected, but something is causing it to fail in the last date column. All of the date columns in the Excel file have the same format, so there is no difference there. However, when I look at the raw inputs it has one column as ISO 8601 and the one failing as a serial date:

"item/Detection_x0020_Date": "2022-03-16T00:00:00.000Z",
"item/Repaired_x0020_Date": null,
"item/Final_x0020_Inspection_x0020_Dat": "44636",

Here you can see the two dates in question in the Excel file, the failing one not in serial format.

Nothing I seem to do gets that last column to work correctly.

I have the same question (0)

All responses (5)

Answers (0)

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report

Re: Some dates causing Excel to SharePoint list to fail

Hello @probey82 ,

in order to grab the date from an integer, please follow the instructions in this article:

https://powerautomatejoy.com/2022/07/25/excel-convert-date-from-string/

Please let me know if the issue is fixed.

If I have answered your question, please mark my post as Solved.

If you like my response, please give it a Thumbs Up.

I may not have all the answers, but I'm curious and passionate enough to keep looking for answers and to keep sharing them.

My blog site about Power Automate: https://powerautomatejoy.com/

BR,

Marco

Was this reply helpful? Yes No
probey82 10 on at

Like (0)

Report
Re: Some dates causing Excel to SharePoint list to fail

I'm trying this out, but I cannot get the first Compose to work correctly. Is this the correct expression?

int(items('Apply_to_each')?['Date'])

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report

Re: Some dates causing Excel to SharePoint list to fail

Hello @probey82 ,

I think you should replace "Date" with your column name.

Please let me know if the issue is fixed.

If I have answered your question, please mark my post as Solved.

If you like my response, please give it a Thumbs Up.

I may not have all the answers, but I'm curious and passionate enough to keep looking for answers and to keep sharing them.

My blog site about Power Automate: https://powerautomatejoy.com/

BR,

Marco

Was this reply helpful? Yes No
probey82 10 on at

Like (0)

Report

Re: Some dates causing Excel to SharePoint list to fail

That is the name. Here's the error message I get:

Unable to process template language expressions in action 'Compose_-_intDate' inputs at line '0' and column '0': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report

Re: Some dates causing Excel to SharePoint list to fail

ok @probey82 ,

I see that your Table column is named "Final_Inspection". Is that right?

So you should replace "Date" with "Final Inspection".

Please let me know if the issue is fixed.

If I have answered your question, please mark my post as Solved.

If you like my response, please give it a Thumbs Up.

I may not have all the answers, but I'm curious and passionate enough to keep looking for answers and to keep sharing them.

My blog site about Power Automate: https://powerautomatejoy.com/

BR,

Marco

Was this reply helpful? Yes No