511
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
#1
André Arnaud de Cal...
293,209
Super User 2025 Season 1
#2
Martin Dráb
231,923
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
