Skip to main content
Dynamics 365 general forum
Suggested answer

Nulling a Lookup with Flow

editSubscribe (0) ShareShare
ReportReport
Posted on by 507

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

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,305 Super User on at
    RE: Nulling a Lookup with Flow

    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?"

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,305 Super User on at
    RE: Nulling a Lookup with Flow

    Lee,

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

  • Lee-Martin Profile Picture
    Lee-Martin 507 on at
    RE: Nulling a Lookup with Flow

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

  • Lee-Martin Profile Picture
    Lee-Martin 507 on at
    RE: Nulling a Lookup with Flow

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

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,305 Super User on at
    RE: Nulling a Lookup with Flow

    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.

  • Lee-Martin Profile Picture
    Lee-Martin 507 on at
    RE: Nulling a Lookup with Flow

    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!

  • Lee-Martin Profile Picture
    Lee-Martin 507 on at
    RE: Nulling a Lookup with Flow

    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

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,305 Super User on at
    RE: Nulling a Lookup with Flow

    Lee,

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

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Sundar…

Industry experts answer burning questions directly from our amazing Community…

Enabling Copilot Case and Conversation…

Agents can easily recap an ongoing chat, transcribe a voice conversation…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 282,978 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,562 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans