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

How to handle null value in lookup/CDS when creating a record

I am trying to set a value on a lookup for the Source Campaign. Sometimes the dynamic data field "Source Campaign" has no data, so my Flow errors out here. How do I handle this? 

saturation_0-1595875571792.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
abm
Super User III
Super User III

Hi @saturation 

 

This is a limitation of the CDS connector actions now.

 

Please vote for this idea so that this should be considered in future release.

https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Allow-Setting-null-value-to-the-lookup-fiel...

 

Currently add an IF condition to check Source Campaign is null or not.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

View solution in original post

3 REPLIES 3
ManishJain
Solution Sage
Solution Sage

Hi @saturation ,

 

you might have to end up doing branching where it contains value and it does not. Setting lookup value as null is not allowed.

 

Thanks 

abm
Super User III
Super User III

Hi @saturation 

 

This is a limitation of the CDS connector actions now.

 

Please vote for this idea so that this should be considered in future release.

https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Allow-Setting-null-value-to-the-lookup-fiel...

 

Currently add an IF condition to check Source Campaign is null or not.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

View solution in original post

v-alzhan-msft
Community Support
Community Support

Hi @saturation ,

 

I agree with @abm  that you could check if the column is null firstly.

 

Best Regards,

Alice

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

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

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (5,407)