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
Lee,
You can use this forum for this purpose - powerusers.microsoft.com/.../PA_Comm_Ideas
Is there somewhere I can provide feedback to Microsoft about this?
Right ok, it seems like an utterly ridiculous situation for something that could previously have been done with a simple null expression.
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.
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!
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
Lee,
Here is an article that describes it - www.msdynamicduo.com/.../how-to-clear-lookup-values-on-updates-using-the-new-cds-connector
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
288,584
Super User
#2
Martin Dráb
225,864
Super User
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (