Microsoft Dynamics 365 | Integration, Dataverse...

Nulling a Lookup with Flow

(0) Share

Report

Posted on by Lee-Martin

515

In an entity I have 3 fields which are lookups to different entities.

How do I null these values in a flow?

I've seen something about unrelating the lookup fields, but I have no requirement to unrelate them from the entity. Simply to null those 3 fields which are there for a specific reason.

Thanks
Lee

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (0)

Report

Lee,

Here is an article that describes it - www.msdynamicduo.com/.../how-to-clear-lookup-values-on-updates-using-the-new-cds-connector

Was this reply helpful? Yes No
Lee-Martin 515 on at

Like (0)

Report

Thank you, I have already read this.

But as I said I do not want to disassociate the link, I want to clear 3 fields.

The fields I have created are not available in the Relationship drop down.

Also

Was this reply helpful? Yes No
Lee-Martin 515 on at

Like (0)

Report

It appears to be a list of 1:N relationships in the Relationship drop down.

The lookups I need to clear are N:1

I do not have the GUID's available for what needs to be cleared from the field. The value of the lookups is irrelevant to this flow. I just need them clearing.

I can't understand why something so simple as just putting null in the field when updating a record has been discontinued!

Was this reply helpful? Yes No
Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Lee,

I'm afraid it is what it is and you can't work around it. In order to clean up your lookup fields, you will have to use disassociate. In order to get those "related" ids that you don't have, you can use "Get Record" to get values of lookups to be used in the Dissasociate operation. And if there is no relationship available - just flip your main entity and related one - in this case, it will be a 1-N relationship.

Good luck.

Was this reply helpful? Yes No
Lee-Martin 515 on at

Like (0)

Report

Right ok, it seems like an utterly ridiculous situation for something that could previously have been done with a simple null expression.

Was this reply helpful? Yes No
Lee-Martin 515 on at

Like (0)

Report

Is there somewhere I can provide feedback to Microsoft about this?

Was this reply helpful? Yes No
Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Lee,

You can use this forum for this purpose - powerusers.microsoft.com/.../PA_Comm_Ideas

Was this reply helpful? Yes No
Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

If my reply (or replies) answers your question take a minute and verify the answer. You can do it by clicking "Yes" at the top of the reply (or replies) under the label "Does this answer your question?"

Was this reply helpful? Yes No