Showing results for 
Search instead for 
Did you mean: 
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'])


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'])


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

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!


Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

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.

Top Solution Authors
Top Kudoed Authors
Users online (45,030)