'Int' error when importing data from Excel sheet in OneDrive into Dataverse Whole number column type

(0) Share

Report

Posted on by eel1

Hi all,

Wonder if you could help me out of a pickle! 🙂

I have a workflow (image attached) which attempts to bring numerous columns from an Excel spreadsheet table (located in OneDrive) into a Dataverse table. This works in part, but I have stumbled upon an error related to a number column and an expression I have. The 'Logged Time' Dataverse column relates to a column in Excel (Total Milliseconds) which is the 'General' type. I have this expression to import the data from that column: int(items('Apply_to_each')?['Total Milliseconds']).

The Dataverse column type is set as 'whole number'.

But I get this error after just a handful of successful columns being imported to the Dataverse table, which is odd, that some are imported, then it errors as below:

"Unable to process template language expressions in action 'Add_a_new_row_to_selected_environment' 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 to put me out of my misery please? 😁

Categories:

Building flows

App flow.JPG

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (1)

Report
@eel1 Could you add a Compose action above the Add New Row to Select Environment action and insert the dynamic content for the Total Milliseconds? Can you run a test and screenshot the output of that Compose action?

Is there a decimal place in your Total Milliseconds value? If so, can you try using this expression?

int(float(items('Apply_to_each')?['Total Milliseconds']))

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No
eel1 56 on at

Like (0)

Report

Thanks a lot @creativeopinion . That did the trick!

Was this reply helpful? Yes No