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
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

@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