Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 general forum
Suggested answer

Nulling a Lookup with Flow

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,313 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,313 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,313 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,313 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

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,768 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,985 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans