cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Connor551
Resolver I
Resolver I

Create Record - Blank Values Causing Problems

Hi all!  Within a 'Create Record' action, I'm getting errors whenever my dynamics content doesn't have a value:
The runtime value '""' to be converted doesn't have the expected format 'Integer/int32

I've tried to solve for this by using if statements (examples below), but I'm still getting the errors.  Any ideas?

if(equals(items('Apply_to_each')['Revenue'], null), null, items('Apply_to_each')['Revenue'])

i've also tried '' to see if the check for null value wasnt working:

if(equals(items('Apply_to_each')['Revenue'], ''), null, items('Apply_to_each')['Revenue'])

 

2 REPLIES 2
Expiscornovus
Super User II
Super User II

Hi @Connor551,

 

Try and use the empty function to check if it is empty. Here is an example, let me know if it works:

if(empty(items('Apply_to_each')?['Revenue']), null, items('Apply_to_each')?['Revenue'])

 

leyburn19
Memorable Member
Memorable Member

Looking at the function you use the word revenue.  Revenue indicates to me currency value which is not an integer.  Are you sure it is  a null value problem. 

 

Put a compose action in the process before the failure.   Run the flow and look at what value teh compose returns.  This might help to analyze your problem

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power Automate User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (31,692)