tag:blogger.com,1999:blog-3970629459363259828.post4792757598685118741..comments2024-03-30T01:08:21.613+13:00Comments on Linn's Power Platform Notebook: How to Set Lookup Column Value in Microsoft Dataverse Connector in Cloud FlowsLinn Zaw Winhttp://www.blogger.com/profile/16015532694415495453noreply@blogger.comBlogger27125tag:blogger.com,1999:blog-3970629459363259828.post-65103357772393282922023-09-09T06:47:56.016+12:002023-09-09T06:47:56.016+12:00Thanks so much for the information in your blog. O...Thanks so much for the information in your blog. One more thing to add is when your custom entity ends with an S, e.g. tomateos, then EntitySetName becomes tomateoses!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-73476151681230242112023-08-21T15:22:10.748+12:002023-08-21T15:22:10.748+12:00Hi WY
The EntitySetName and the brackets need to ...Hi WY<br /><br />The EntitySetName and the brackets need to be set in the input of the column (as in the first image below). If you use Expression to set the field with EntitySetName (as in the 2nd image below), you will get the following error .<br /><br />https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEic5qJ9fSZBPij3cmzlQrBQvCX6Pgo9grGOgDx0Zg1wQgeSsehOIMpOb-SrTbvhXFaDsfzwxIm5GOA-SClnC7oaOb8xS_0VnXrXOmKur3Oa9HqrI7GeYNIZJkhvkYZOyri3CgvDa-i1t6f3ghBLcBWqJQWonNvegNxrSkRImzSRHx8YPsgF_HTVuDVlNiDK/s993/Adding%20EntitySetName.pngLinn Zaw Winhttps://www.blogger.com/profile/16015532694415495453noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-6927004417543635782023-08-17T17:29:53.057+12:002023-08-17T17:29:53.057+12:00Hi Lynn, I am trying to create a note and the rega...Hi Lynn, I am trying to create a note and the regarding is a lookup to a custom entity called 'Loyalty Membership'. At first, I was just setting the GUID in the regarding field and was obtaining the error ODataUnrecognizedPathException. Then I cam across your blog. As per your recommendation, I have checked the entitysetname via the Metadata browser tool and the entitly set name is mk_loyaltymemberships. I have then set the regarding field to mk_loyaltymemberships(GUID). The error "Unable to process template language expressions in action 'Create_Note' inputs at line '0' and column '0': 'The template function 'mk_loyaltymemberships' is not defined or not valid.'." is now being obtained. <br />Is there anything that I have missed out? <br />Thanks in advance.<br />WYAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-82466929855030873532023-05-23T22:24:10.385+12:002023-05-23T22:24:10.385+12:00I've replied in that forum thread. Please mark...I've replied in that forum thread. Please mark it as answer if it solves your problem.Linn Zaw Winhttps://www.blogger.com/profile/16015532694415495453noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-81771041410915297772023-05-23T20:33:41.488+12:002023-05-23T20:33:41.488+12:00Hi Linn. I got the link to your blog in one of my ...Hi Linn. I got the link to your blog in one of my posts on Power Platform community. I was wondering you maybe have a solution for my business case. I'm trying to update 'Owner' field in Dataverse with Power Automate. My Dataverse table has a 'Supervisor email' field and I was wondering if there's a way to retrieve Dataverse user ID (not AAD ID) from it and then update Owner field? <br />Link to my post: https://powerusers.microsoft.com/t5/Microsoft-Dataverse/How-to-retrieve-user-ID-from-Dataverse-table-based-on-email/m-p/2165595#M30051<br /><br />Thanks!<br />Pawel PomaranskiPawełhttps://www.blogger.com/profile/16648489321114503857noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-74297880587271627872022-12-17T08:09:43.474+13:002022-12-17T08:09:43.474+13:00Hi Linn, thank you so much for your post, very hel...Hi Linn, thank you so much for your post, very helpful. I have a requirement, that have a Contact-based folder structure in SharePoint, but I want to same/similar folder structure of the Account, or even other entity like Opportunity in SharePoint. Can I use same way you introduced to do that?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-34752482875289106132022-10-21T05:10:03.624+13:002022-10-21T05:10:03.624+13:00To know how to write to complex columns in dataver...To know how to write to complex columns in dataverse , go to my YouTube video .<br /><br />I have explained in details , how to update dataverse lookup column using power automate <br />https://www.youtube.com/watch?v=hstUL0UfnI4<br /><br /><br /><br />$MKhttps://www.blogger.com/profile/10367385139936160598noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-39215093496507725412021-12-17T00:10:04.888+13:002021-12-17T00:10:04.888+13:00To retrieve the GUID for the owner, you will need...To retrieve the GUID for the owner, you will need to call List Rows action on the Users table with the filter "fullname eq <>" and get the GUID of the matching record.Linn Zaw Winhttps://www.blogger.com/profile/16015532694415495453noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-5228145719622164422021-12-16T04:14:09.963+13:002021-12-16T04:14:09.963+13:00Hi Linn
I am trying to populate owner field on op...Hi Linn<br /><br />I am trying to populate owner field on opportunity entity from the excel records.<br />Only name of owner is given, no guid.<br /><br />Can you please help me with the syntax to set the owner lookup field from the name of owner.<br /><br />Thanks in advanceAnonymoushttps://www.blogger.com/profile/00963526958939611512noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-34447148626167529912021-11-28T19:37:50.582+13:002021-11-28T19:37:50.582+13:00Thanks for your comment, Ramesh. Glad to know that...Thanks for your comment, Ramesh. Glad to know that it helps.Linn Zaw Winhttps://www.blogger.com/profile/16015532694415495453noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-4167680405361197682021-11-24T21:11:21.258+13:002021-11-24T21:11:21.258+13:00This blog post is a magic. Exactly what I wanted. ...This blog post is a magic. Exactly what I wanted. Thanks a lot Linn.Ramesh Mukkahttps://www.blogger.com/profile/12929665917968602865noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-87027189588063146942021-10-21T09:49:01.988+13:002021-10-21T09:49:01.988+13:00I'm glad you learnt about the EntirySetName fr...I'm glad you learnt about the EntirySetName from my blog post. 😊Linn Zaw Winhttps://www.blogger.com/profile/16015532694415495453noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-48315227088691585892021-10-21T03:03:09.840+13:002021-10-21T03:03:09.840+13:00Thanks a ton! at last your blog solved my problem....Thanks a ton! at last your blog solved my problem. The issue is with the SetName and the Plural Name, everywhere it's mentioned as Plural name but you have explained it clearly. Thanks again!Anonymoushttps://www.blogger.com/profile/13758056026711714592noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-62467372287785638732021-07-13T22:34:09.990+12:002021-07-13T22:34:09.990+12:00Hey dlutchy,
When referencing the lookup table do...Hey dlutchy,<br /><br />When referencing the lookup table do you have to use the GUID only. The name can be duplicate and based on how the MS Dataverse API works, GUID is required to populate the lookup column value.<br /><br />Normally, we create the rows of the reference table (e.g. Country) with a script or tool so that the GUID is same across different environments. Otherwise, you will have to "List rows" and find the GUID of the row by name before referencing the lookup.Linn Zaw Winhttps://www.blogger.com/profile/16015532694415495453noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-43886578288016775942021-07-05T13:52:34.645+12:002021-07-05T13:52:34.645+12:00Hi Lynn,
Great article thanks. When referencing ...Hi Lynn, <br /><br />Great article thanks. When referencing the lookup table do you have to use the GUID or can you just use a name field.<br />For instance I want to reference the Contact Name "John Smith" rather that an ID 8046dfOAB......<br /><br />This is important for me becuase I am using the flow across different environments and have to keep getting a different GUID for the same Table (but in different environments)dlutchyhttps://www.blogger.com/profile/08057439016413649741noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-82442351716529968582021-04-26T01:08:48.855+12:002021-04-26T01:08:48.855+12:00I'm glad it helped to solve your problem 😊
I ...I'm glad it helped to solve your problem 😊<br />I really appreciate that you took some time to leave this comment. It really made my day. ☺️Linn Zaw Winhttps://www.blogger.com/profile/16015532694415495453noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-57256488924849079232021-04-26T00:09:45.610+12:002021-04-26T00:09:45.610+12:00Hi Linn,
I know this is a somewhat older article b...Hi Linn,<br />I know this is a somewhat older article but I just wanted to say thank you for your contribution here. I've just spent the better part of 4 hours trying to debug this issue and every other article I read neglected to point out the need to use the EntitySetName and not the plural display name. That guidance and also the helpful API link to identify the Set name made all the difference in the wee hours of the morning. Thank you!Anonymoushttps://www.blogger.com/profile/04400349043269640381noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-71158513508809724462021-03-24T00:33:03.260+13:002021-03-24T00:33:03.260+13:00Yes, you can populate the GUID value to the lookup...Yes, you can populate the GUID value to the lookup field with <>(<>) format as mentioned in the blog post.<br />e.g. contacts(a40675ed-84bc-43ca-bf4d-57e98d49d58b)Linn Zaw Winhttps://www.blogger.com/profile/16015532694415495453noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-76836903487729206812021-03-23T15:52:46.660+13:002021-03-23T15:52:46.660+13:00Hi, it's nice to see your blog. But I have a q...Hi, it's nice to see your blog. But I have a question can I populate guid to the lookup value of the field?Anonymoushttps://www.blogger.com/profile/06339352938004286558noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-44423905869403916202020-08-04T21:42:57.151+12:002020-08-04T21:42:57.151+12:00As mentioned in the blog post, it needs to be pref...As mentioned in the blog post, it needs to be prefixed with the plural version of the entity schemaname (aka EntitySetName)<br />What is the entity type of "Lead PM"?<br /><br />Is it the Contact entity? If so, it should be something like this:<br />contacts(dynamicfield)<br /><br />Or is it the User entity? If so, it should be something like this:<br />systemusers(dynamicfield)<br /><br />If it is the custom entity, find out the EntitySetName from API URL.<br />[Organization URI]/api/data/v9.1Linn Zaw Winhttps://www.blogger.com/profile/16015532694415495453noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-28042702337631870782020-08-04T12:16:37.694+12:002020-08-04T12:16:37.694+12:00Hi Linn! Great post. Could you kindly tell me what...Hi Linn! Great post. Could you kindly tell me what I am doing wrong in this case? I am trying to populate my lookup field in CRM with data coming from Cosmos DB.<br /><br />For instance, I have a field within CRM called LEAD PM<br />When I am in my logic app, I add this parameter, which is Lead PM and then when I add the dynamic field which contains my values, this fails to work.<br /><br />I am doing this:<br />Lead PM(dynamicfield)<br /><br />and this is not working. Please add some suggestion. Thank youBeautifullyMadehttps://www.blogger.com/profile/04812690241797551231noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-36477702418728434122020-06-05T16:44:54.371+12:002020-06-05T16:44:54.371+12:00Thanks Linn. It works like a charm !!Thanks Linn. It works like a charm !!Scorpionhttps://www.blogger.com/profile/05998332781986239863noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-53863803827712227292020-01-16T13:35:22.015+13:002020-01-16T13:35:22.015+13:00It is CDS (Current) that is having a problem with ...It is CDS (Current) that is having a problem with setting null to lookup field.<br />CDS works fine but I want to avoid using it as much as possible so that I can deploy the flow to the target environment without re-authorising the connection. 😁Linn Zaw Winhttps://www.blogger.com/profile/16015532694415495453noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-39504255227699672972020-01-16T07:01:23.613+13:002020-01-16T07:01:23.613+13:00Please use Expression and type null Please use Expression and type null manishhttps://www.blogger.com/profile/13592005757574407769noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-84071636225641685432020-01-16T07:00:33.444+13:002020-01-16T07:00:33.444+13:00Hi Linn,
I am wondering if you are using CDS or C...Hi Linn,<br /><br />I am wondering if you are using CDS or CDS(Current) . Just now I tried using Update a record action using CDS and setting the lookup to null works for me . Please let me know if it works for you.<br /><br />Thanksmanishhttps://www.blogger.com/profile/13592005757574407769noreply@blogger.com