tag:blogger.com,1999:blog-3970629459363259828.post6262739176595159157..comments2024-03-30T01:08:21.613+13:00Comments on Linn's Power Platform Notebook: How to Set Lookup Fields with Null Value from Dynamic Content in Microsoft Dataverse ConnectorLinn Zaw Winhttp://www.blogger.com/profile/16015532694415495453noreply@blogger.comBlogger13125tag:blogger.com,1999:blog-3970629459363259828.post-55765581220029351022024-01-17T04:02:24.734+13:002024-01-17T04:02:24.734+13:00Same problem for meSame problem for meAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-90507221689880558912023-09-05T23:21:28.942+12:002023-09-05T23:21:28.942+12:00Thank you! Thank you! Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-16662904736863848012022-08-13T19:20:14.714+12:002022-08-13T19:20:14.714+12:00Hey Linn,
Thanks for your post on how to set looku...Hey Linn,<br />Thanks for your post on how to set lookup fields with null. It is working fine, but in my scenario, the lookup field may have values or may not have values. By following your above method, the lookup field is not updating even though there is value in the source entity. Please advise.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-63649015095157725492022-08-11T00:36:50.927+12:002022-08-11T00:36:50.927+12:00Hey Linn - great info as always! I'm looking i...Hey Linn - great info as always! I'm looking into a similar nullable issue but with a Dataverse choice field, is it possible?Matt Burrhttps://www.linkedin.com/in/mb365/noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-50024671767812466122022-03-25T19:18:57.456+13:002022-03-25T19:18:57.456+13:00Thanks for sharing your experience with us. I have...Thanks for sharing your experience with us. I have never tried the Web API batch mode but it is good to know about it.Linn Zaw Winhttps://www.blogger.com/profile/16015532694415495453noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-77090129782889284242022-02-17T05:25:39.301+13:002022-02-17T05:25:39.301+13:00The lookup reset only works in single record mode....The lookup reset only works in single record mode. If you use the Web API batch mode (https://docs.microsoft.com/en-us/odata/webapi/batch), the lookup reset doesn't work. I would consider that a bug in the Microsoft Dataverse API.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-23568907583204176572022-01-19T14:54:36.156+13:002022-01-19T14:54:36.156+13:00Thanks, Ravishchandra 😉Thanks, Ravishchandra 😉Linn Zaw Winhttps://www.blogger.com/profile/16015532694415495453noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-64572677459081475412021-12-30T23:33:15.831+13:002021-12-30T23:33:15.831+13:00Great Blog Lin!!!Great Blog Lin!!!Ravishchandra Guptahttps://www.blogger.com/profile/01196681609155996877noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-43130668088147337872021-10-03T10:39:06.160+13:002021-10-03T10:39:06.160+13:00I have added a sample Update a row step with expr...I have added a sample Update a row step with expression and screenshots to update the lookup with Null value. Try to follow those samples and if you still have a problem updating the lookup with Null value, let me know with your expression.<br />https://linnzawwin.blogspot.com/2020/07/how-to-set-lookup-fields-with-null.html#updatenullLinn Zaw Winhttps://www.blogger.com/profile/16015532694415495453noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-18294062480953027302021-10-01T06:40:02.519+13:002021-10-01T06:40:02.519+13:00Thanks for the post. I am using Microsoft Datavers...Thanks for the post. I am using Microsoft Dataverse Update a Row step to populate a look up field. It works fine if it has a value but failing to update the lookup with Null value even after trying to set it to null or an empty string in the if condition. Kindly let me know if there is any thing to consider for it to be working. Thanks for the help.Mahathihttps://www.blogger.com/profile/15563479683955548207noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-3951695322818080652021-07-16T22:07:51.228+12:002021-07-16T22:07:51.228+12:00Indeed, Nielf. It's not citizen developer frie...Indeed, Nielf. It's not citizen developer friendly at all. 😐Linn Zaw Winhttps://www.blogger.com/profile/16015532694415495453noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-25364895678534127352021-07-16T17:59:35.952+12:002021-07-16T17:59:35.952+12:00Thanks for the post , Linn. It was a great help to...Thanks for the post , Linn. It was a great help to this frustrating issue.<br /><br />Working with lookups in Power Automate has become such as hassle with the newest Dataverse/CDS connector. Just having to know the plural name of the entity when you set a lookup - and using this expression will scare aware citizen developers. Nielfnoreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-19176499576836454842020-08-05T19:49:02.314+12:002020-08-05T19:49:02.314+12:00Good blog, well done Linn!Good blog, well done Linn!Arjhttps://www.blogger.com/profile/09819720633027998790noreply@blogger.com