Convert Excel Text to Lookup Value in SP, Int64 Error

(1) Share

Report

Posted on by jamescosten

643

In my flow I keep getting an error when trying to take an excel value and populating a Lookup column in SP.

The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/ToolNumber/Id' is required to be of type 'Integer/int64'. The runtime value '"B007"' to be converted doesn't have the expected format 'Integer/int64'.

How do I convert Excel Text Fields to Integer/int64 values that sharepoint lookup columns can read?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

The root cause here is your value in your Excel sheet. "B007" cannot be converted to an int64 because it is text. My recommendation is to update your List ToolNumberID to be a string column. Resubmit. This will resolve this issue.

------------------------------------------------

⭐ If this was helpful, please like and/or mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
jamescosten 643 on at

Like (1)

Report

How do i go about converting the Excel number to INT value for Sharepoint?

Was this reply helpful? Yes No
Suggested answer

trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

You can wrap your dynamic content from you excel table in the expression INT(). But as stated, "B007" is a string and will not convert to an integer.

------------------------------------------------

⭐ If this was helpful, please like and/or mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

Hey there!

I am following up on this post convert excel text to lookup value in sp, int64 error in this category building flows from 10/28/2024. I know the post is a little older, but it is a common question here so wanted to take a moment and follow-up. I see there have been 3 replies and 1 likes and asking if your question has been answered. If so, please help the community out by completing one or more of the following actions! Thanks in advance!

Easy as 1-2-3 ‼️💯⭐😎🆒🙏

1) Mark a reply as a verified answer - this is essential, and it helps others with the same general question find this thread. ✅

2) You can also mark one of more replies as a verified answer. Please take a moment and give the author credit for volunteering their time. ✌️

3) Like one or more replies. Kudos always greatly appreciated! 👍

Pro tip: if you found your own solution or workaround, feel free to add a reply to your own post and mark it as the solution too! The goal is to get this thread marked with a verified answer by anyone that finds one or more replies helpful!

Again, thanks in advance for reading and responding, always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No
trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

If I can help with anything else please let me know or tag me in a future post, I enjoy reading and answering questions. Always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No