cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bhitchlockfcs
Resolver II
Resolver II

Is it possible to pass an empty result from an expression in a common data service update record action?

I have a Flow which copies one value from a source entity to a target entity. I want the update of this field to be optional based on another boolean field. Is it possible to have an expression evaluate to an empty value such that the result is the same as if I left the field blank in the update record action? 

 

I am using an expression similar to below.

 

if(equals(outputs('Get_the_Target_Record')?['body/bht_dontcopy'],false),outputs('Get_the_Source_Record')?['body/bht_optionalnumber'],  insert empty/no value here )

 

 

expressionoption1.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
bhitchlockfcs
Resolver II
Resolver II

Figured it out.

 

I put the existing property into the else part of my expression.

View solution in original post

2 REPLIES 2
bhitchlockfcs
Resolver II
Resolver II

Figured it out.

 

I put the existing property into the else part of my expression.

Thank you for providing the solution in this post @bhitchlockfcs !

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,654)