Answered

Does anyone know how to handle empty lookup in update action of cds?

(1) Share

Report

Posted on by nmk

193

I am updating one entity with two lookups. The GUID for the lookups are in two variables which are getting populated from List record action of another table.

Everything's work fine when variable contain the guid however, it's failing when there's no record from the list record action and variable is empty. Instead of nullifying the lookup field, update action is giving an error.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

ScottShearer 25,290 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@nmk

Take a look at the coalesce() expression. It is designed to return the first non-null value from the parameters presented to it. In other words, you can provide a default value if the lookup is null.

Was this reply helpful? Yes No
nmk 193 on at

Like (0)

Report
Copy link

Link copied!

@ScottShearer Thanks.

No i don't want to skip if it's empty. I want to nullify the lookup if there's no value meaning I want to remove the existing value on the lookup

e.g. if lookup already has 'A' as value and if I don't get any value from List Record, I should update the existing A to null.

Was this reply helpful? Yes No
v-alzhan-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @nmk ,

Would you please share a screenshot of your flow and explain more details about your requirement?

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.

Was this reply helpful? Yes No
Verified answer

nmk 193 on at

Like (0)

Report
Copy link

Link copied!

Thank you, everyone.

No, we can't assign null variables/value to lookup. If someone needed to blank out the lookup then it can be done through unrelated action.

Was this reply helpful? Yes No
Digit89 33 on at

Like (0)

Report
Copy link

Link copied!

To specify a bit more the previous answer, you can use the CDS "Unrelate Record" action as a workaround while MS fix the possibility to set a null value (February 2021).
Reference.

Was this reply helpful? Yes No