Answered

Automating Excel Data to SharePoint List-- Integer/int64 problems

(0) Share

Report

Posted on by TF-23071417-0

Hi all, I am brand new to Power Automate and I am trying to take a weekly .csv file, clean and format it with Power Query, then using PA to automate the file's contents to a SharePoint List. I am following the video from Reza Doranni: https://www.youtube.com/watch?v=uEZI_b1Gs-k

I have mapped the columns in the Create Item action and after I run the test flow, I get the following error message:

OpenApiOperationParameterTypeConversionFailed. The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/Accounts/Id' is required to be of type 'Integer/int64'. The runtime value '"ABC, Inc. - Baltimore, MD - Shoes"' to be converted doesn't have the expected format 'Integer/int64'.

I have tried converting my Account Id column to integer by using this expression: int(item()?['Account'])

but I get the following error:

InvalidTemplate. Unable to process template language expressions in action 'Create_item' 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.'.

Any ideas? I have attached my sample data and screenshots of my flow.

help screenshot.PNG help screenshot 2.PNG

CAPA test data.xlsx

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-chengfen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @hazwoper ,
From the bug report you provided:
The problem is: what is populated is not the same type as the column.
Can you tell me the type of Account Id column in Sharepoint?
if a numeric column
Please change the Account Id of sharepoint to a text column because in the excel sheet you provided, Account is of type text

Best Regards
Cheng Feng

Was this reply helpful? Yes No
TF-23071417-0 5 on at

Like (0)

Report
Copy link

Link copied!

@v-chengfen-msft Thank you! It looks like that worked. My SharePoint list columns for some of the columns-- including Account, Region, and Account Size-- were of the "Lookup" data type. I deleted those columns and made new ones, changing them to "Short Text" type. I ran the PA test flow and it was a success.

Was this reply helpful? Yes No