Power Automate update sharepoint list from excel file

(0) Share

Report

Posted on by JoJM

Cannot seem to get my sharepoint list to update from my excel and yes yes yes I have tried

length(outputs('Get_items')?['body']) and

length(outputs('Get_items')?['body/values'])

nothing seems to work. At a complete loss.

Categories:

Building flows

I have the same question (0)

All responses (10)

Answers (0)

Ventit 422 on at

Like (0)

Report

Re: Power Automate update sharepoint list from excel file

May as well stay at a complete loss if that is all the info you can give us. I assume you are using the action for the excel to list rows in table?. Where are you getting the length value from as you action would be correct, although to me that is based on a SP list not a list rows in table. Please provide all your steps

Was this reply helpful? Yes No
JoJM 18 on at

Like (0)

Report

Re: Power Automate update sharepoint list from excel file

Was this reply helpful? Yes No
jaredbidlow 256 on at

Like (0)

Report

Re: Power Automate update sharepoint list from excel file

If using the length formula, use the "length is not equal to null" method.

Was this reply helpful? Yes No
JoJM 18 on at

Like (0)

Report

Re: Power Automate update sharepoint list from excel file

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

Was this reply helpful? Yes No
Ventit 422 on at

Like (0)

Report

Re: Power Automate update sharepoint list from excel file

I think your issue relates to the excel column in the get items filter to the SP list. Where exactly is it failing? can you share an image of a run. Does it show fail on the condition or the Get Items. I cannot quite see the Filter on the SP list. Is it a numeric filter? Like ID eq ??? It may be your ??? may be getting passed as a string. Initialize an integer variable at the start. Then in your apply to each Set the variable above the Get Items. Use expression int(excelfield) and then use this in your SP filter. To put the variable above you may need to firstly create it below teh Get Items and then drag the Get Items below it as it will not allow you to put it above any other way

Was this reply helpful? Yes No
Riyaz_riz11 3,844 Super User 2025 Season 2 on at

Like (1)

Report

Re: Power Automate update sharepoint list from excel file

Hi @Ventit

Please refer this for conversion datetime, it was throwing issue with datetime, so while inserting you need to convert using expression and pass variable inside.

formatDateTime( [your date here] , 'MM/dd hh:mm:tt')

[your date here] it defines pass your variable

https://powerusers.microsoft.com/t5/General-Power-Automate/Formatting-Date-And-time-in-MS-Flow/td-p/138363

Regards

Ahammad Riyaz

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
KvB1 1,596 on at

Like (0)

Report

Re: Power Automate update sharepoint list from excel file

Excel stores dates as a number, which is the amount of days passed since 31-12-1899

You are then trying to update a sharepoint column which has been defined as a date column, with an integer, hence the error you are receiving

To format the integer from excel to the correct date/time format for sharepoint, see:
https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Excel-Date-changes-in-Power-Automate/ba-p/799959

Was this reply helpful? Yes No
JoJM 18 on at

Like (0)

Report

Re: Power Automate update sharepoint list from excel file

Got my flow to work by adding 6 variables and adding dates and a bunch of condition statements, with six or 8 lines but just tried to add the rest of my data and this is the error I am getting now out of condition 2.

InvalidTemplate. Unable to process template language expressions in action 'Set_variable' 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
JoJM 18 on at

Like (0)

Report

Re: Power Automate update sharepoint list from excel file

Was this reply helpful? Yes No
JoJM 18 on at

Like (0)

Report

Re: Power Automate update sharepoint list from excel file

Was this reply helpful? Yes No