web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Create Item Error - Er...

Power Automate

Unanswered

Create Item Error - Error details: Input parameter 'item/field_7' is required to be of type 'Number/double'.

(0) Share

Report

Report

Posted on by wonka1234

920 Super User 2024 Season 1

Hi,

How come I am getting this error?

My values are "general" format in an excel table.

I am using this expression to try to create item - items('Apply_to_each_3')?['2023_01_16']

What am I doing wrong?

Thanks.

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

grantjenkins 11,063 Moderator on at

Like (1)

Report
Copy link

Link copied!
Can you try wrapping your field inside a float expression so it converts it from string to float. This assumes there will always be a value and it will be a number.

float(items('Apply_to_each_3')?['2023_01_16'])

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@grantjenkins thanks, i wonder if it is because I have blank values to

The runtime value '""' to be converted doesn't have the expected format 'Number/double'.

maybe i need to deal with nulls?

Was this reply helpful? Yes No

Join the conversation