Shane these types of videos may not attract the most views but they are highly valuable. I am sure I could have figured this out but you saved me hours of work (and frustration).
Thanks Shane. I have been on the Dataverse/Powerapps journey for a few years now and there have been a few challenges that I dont think I would have gotten over if it wasn't for your videos. Just as you described at the beginning of this video, there are a few explanations on how to complete this task around, but none of them offer a definitive and repeatable process to achieve it. Your trick with the URL/API call provides the right result every time rather than guessing. In a flow in my case where I needed to write to multiple lookup fields at the same time, the error output is totally useless as it doesn't elaborate on which field is causing the error and increases the diagnostic time exponentially. You are another member of this community that has brought me closer to my goals. I'll be sure to pay it forward.
Shane I can't thank you enough I stumbled upon your video by accident after countless hours of troubleshooting a dataverse issue even after finding a lot of blogs my issue wasn't listed but your video gave me the insight needed to finally finish my flow. Thank you.
I think the more people understand about Dataverse the higher the demand will be. I'm really struggling to find resources to help me understand Dataverse and it's still very new and a lot of people haven't heard of it yet. On another note...I really appreciate all the videos Shane you've transformed my life and career so THANK YOU!
Thanks a lot Shane for another awesome video! I suggest another simpler trick to get the plural internal name without resorting to the API. In PowerAutomate, add a Dataverse action, select the table of your interest, and then peek code. You'll find its plural name right next to "entityName" :)
Thanks so much for this Shane. I was doing some development work during my holidays and this stumped me totally yesterday night. So then with much trepidation this morning, I did the magic URL incantation, found out the secret Entity Set Name word and placed in in that pesky lookup field. And it worked :) Like how you took the time to research all the hidden nuts and bolts behind Data verse. Hopefully Microsoft gives you the due recognition because a lot of enterprise clients aren't using Dataverse because of the lack of knowledge. Your video helps demystify this and can help spur adoption.
Thanks! I had about 20 tabs up of Microsoft docs and forum posts and didn't find this way to find the plural entity name.. I was looking in all the wrong places the whole time - finally got my first green checkmark after this video!! 🍻
Allways the same. Blocked on a triccky issue on PowerPlatform, looking for the solution for hours on Google and finally found a Shane Young video explaining everything I need to solve my issue. Thanks a lot, fun videos, very clear explainations, always learning something. Please, continue to make us progress on this techno!
I could kiss you right now for the frustration you have saved me! I have been trying to figure this thing out for days, thank you for explaining it quickly and efficiently!
Could not agree with you more Shane about how stupid HARD this is. I sure hope someone, if not several someone's over at MS are totally embarrassed at what a pain this is! (I wonder if it's this big a nightmare in Azure Logic Apps?!) THANK YOU THANK YOU THANK YOU for this video! I've been banging on this issue all dang day!
Shane you are THE MAN!!! This was exactly what I was looking for to solve the same issue you had - spending hours trying to figure this out. Thank you, thank you thank you! I only needed to get to the 12 minute mark where you explain how to get the plural name of the lookup table and bingo! WOOOOHOOOOO....
Thank you Shane, ... If it is of any consolation, I had to view your video several times before thinking I understood ;-) . Thank you for your work. This is amazing that we call it low / no code, ... just to bulk upload a table containing lookup.
Thank thank thank! Nothing else left to say. (Came here after watching your video on how to save to Lookups within PowerApps, thanks for that as well.)
Thank you for this great video Shane. This is why is so important to create tables with singular names so we avoid that strange entity name. I think it's not sufficiently emphazised in the documentation. It says the following: "Display name This is the singular name for the table that will be shown in the app. This can be changed later."
Thanks a lot Shane for such an informative video. Just one point to add here is that for Dataverse(legacy) actions, it will be just GUID instead of the plural name and then GUID.
Just came across this bit of gold - Thank you!! I always struggle with this. Often, I'm able to use the OData Id, where I expect this method would also work (and using just the "unique identifier for the ..." does not work). Not sure if that Odata Id is a new thing since this video was created. It also doesn't always work, so I'm glad to have the right method.
The set name is now available to be copied directly from the properties view of the table in Dataverse rather than using the URL. Click the `Tools` drop drown and you will see an option to `Copy Set Name` 👍
16:43....I wasted my whole day to figure out this.... That "es" ate up my whole day 🙃.. Thanks a lot Shane!! At last your video helped me as always......Thanks a million!! 😀
Another great video Shane. Please please please make more Dataverse videos. fFor security reasons my employer only uses Dataverse. One idea: what are the pros and cons of using an auto number and/or the GUID in Dataverse. This is causing me pain at the moment. Thanks, Dave
Man i can not thank you enough, even though this video is two years old, you pulled me out of my frustration. I just had to remove those damn single quotes xD
Just wanted to let you know that you showed me that my cast to a lookup was supposed to be "systemusers" and not "systemuser". I hadn't used any plural names before so I had no idea. I was stuck on that for awhile, so thank you.
I find Dataverse useful because it allows me to reference views in Dataverse that have 2000 items or fewer in which is how I try to skirt delegation. (Please correct me if I’m wrong about that.) My point is that although it’s not as common as SharePoint, Dataverse is my go-to. I also find the way you can custom create query filter views from model driven apps is helpful. If I’m not sure of results returned from a canvas created expression I check it using the model driven Dataverse views. Bottom line, Dataverse can do more than SharePoint so more Dataverse is very much appreciated. Thank you.
Thanks Shane young you are amazing person i have learned many things from you and i will remember this on every moment of my life that you are providing me really hard core MS CRM Consultant Thhhhaaaannnnnnnnkkkkkssssss !!!!!! aaaaaaa LooTTTTTTTTT
Hello Shane, Thanks for your amazing videos ! Juste for some who will encoure an error ( Bad Request Error ) Try to put just the id of the lookup field that would be fine ( i faced this error and did that ) Sharing is caring
Great video man, I am heavily using Dataverse with Flows so more videos on this would be great. Especially when working with data from external sources like MS SQL ie Dataflows.
Thanks, Shane! Your videos are always helpful! Any idea how the process would change if you inserted a new row that had two favorite toys (option set that allows multiple selections)?
Hey Shane! I'm really struggling with this - I have a Column in my table called, 'full name' which is a text column. In the same column I have a lookup called, 'system user'. I just want to copy the full name column into the lookup column to save me having to manually key in each one. I have 1000 rows of data and I cant seem to get this video to run the flow on each item to copy it over - please could you help?!
Thanks Shane! This Compose function seems more trouble than it is worth though. Any harm in limiting the list rows to one row, and then keeping the For Each loop (which would only run on one record)?
Thanks for the great video. I was trying to load data using a DataFlow, but it didn't allow me to write to a relationship lookup column. This video helped me get a Power Automate Flow working! I found that when Exporting data from a table, the CSV file that is downloaded is named with the table Plural name, at least for the ones I exported. I'm not sure if it will always hold true.
Great, Shane, thanks--Am wondering if this could be a workaround towards creating relationships while I wait to see if my org will turn on the PowerApps Office Add in. Since we don't have the Automate add-in either, probably not, so it would be challenging to get all the dimensions entered so there would GUID's to look up in the first place. But maybe initial data could go from Excel to a SharePoint list to a Flow to Dataverse...but for Teams? I did see "Premium" on the connectors you were using so not sure if this will for for Teams vs Pro. Ponder ponder....
@@ShanesCows Finally taking the plunge here, Shane! I tried Andrea Pinillos' approach during the dataflow stage to no avail (ruclips.net/video/SueC1d2xUNQ/видео.html) then gave a ForAll / Relate formula within an app one last try (using a 3rd data source so the ForAll wouldn't be operating on itself), and am now back to Power Automate. I think it might be easier with existing records using the "Relate Rows" Dataverse Power Automate function, but PA doesn't list my custom relationship, just some default ones, and it doesn't like when I enter it as a custom value, hmmmm.....
Hi Shane . Using your example, you can now use /cr622_chewytoyses/'_cr662_chewystoys_value' which gives you the GUID of the toy. This returns the Primary Name Column of the lookup table. So the format is /lookup table/'_lookup column name_value'. If you List Rows in Chewy's Toys, Chewy's Toy (Value) is available in the dynamic content of the Add new row section of your Flow.
Hi Paul, I'm very interested in your alternative expression. I failed to get the GUID with Shane expression: First(...?['chewystoysid'])). But if I type in directly the GUID retrieved from the Lookuptable Excel export then it works. ; /LookupPluralNametable(GUID) ; If I type your expression as input of Favorite Toys(Chewy's Toys) I have a syntax Error. It's amazing why it's so difficult to get dynamically a row GUID, while a few connectors ask for Row GUID input. I certainly missed something or the entire picture ;-)
This is 2024. This RUclips Video is the only video that Google has to recommend. THIS VIDEO IS JUST WRONG. JUST AN FYI TO EVERYONE: Step 1. Go to the Dataverse table you are using in the Lookup Column. Go to the Properties and Copy the "Logical name" of that table. Again. Step 2. For reference we are here @13:20. PASTE the logical name in the Lookup Column box. for the example in the video it might look something like "new_systemuser" Step 3. You need to put in the row ID of the thing you want. So the @7:22, where Shane is filtering his email. Step 4. The end result in that lookup column should be similar to "new_systemuser(Outputs('Compose'))"
very nice video. Thank you ! I try to find a way to get dataverse choice column guid but cant find any info on line. Can you also give some direction on choice column? Thanks!
The Excel data would most likely just be text. So you would need to write logic to take your Excel Text value of "Red" and then find the correct record in Dataverse to map to. Not trivial but possible. Probably end up using an oData filter or lots of conditionals or a switch. Sorry, I don't have an exact video
Is there still no way to fill the lookup column using an Alternate Key? Why does Dataverse allow setting keys for tables if we can't use them in Power Automate?
Hi Shane, That was a great video. Thanks. I'm wondering if you could help me out. I have a contact record that I've done another lookup to the contact table to add that users manager. I'm having trouble accessing the GUID of the lookup table. I thought this should be easy but everything I have tried has not returned anything.
I keep getting an error in the add row step : ')' or ',' expected at position 4 in '(test-ID-4)'. test-ID-4 is the correct output of compose... what is happening? Thanks
I never comment but I have been racking my brain on this issue. I have a SPO list that I need to import nightly and in that list there is a lookup column. I need it to convert and get the name into the dataverse table. Running into a lot of issues. This is great if I KNEW what name would be picked every time but I don't :(
Taylor you have to build logic that dynamically deals with it. Maybe use a Switch action and then have a path for each column value you have. It sucks, but I don't have a magic bullet other than brute force.
Hi Shane. Great video, thanks for your advice on this. I have a query which may take this one step further.... I have a flow where I am doing exactly what you have shown here, and inputting data into a lookup field using the plural of the entity list. That one is working well. I have an additional field which is an "Expand Query", where I am pulling contact information from a related table, and it also needs to go into the target table also with a lookup field. The expression "create new row" expression which uses the output from an "Expand Query" appears to be different from what you have outlined here. Have you discovered the expression for this? Thanks again. Peter
Hey Shane, LOOOOONG time fan, first time I think I have commented with a question though. (Just so you know, sometimes I set you to binge mode (eventually Ill need the info I figure haha). Anyway, thanks for this video - when I watched it I wasn't really looking for a solution, but sure enough a couple of use cases have since come up. (I still struggle somewhat with the differences between all of the ID's and GUID's and row numbers etc when it comes to using them in Power Automate, clearly this is something that MS needs to unify or at least come up with some clear terminology for). I know this video doesn't quite cover my exact situation (actually, this is the first of your videos I have actually struggled to get my head around the why's of doing it the way you have done it). So I thought I would through this one at you while I go down the rabbit hole myself. Perhaps it would be a good topic/use case for a future video? I have an N:Many relationship custom field added to my Contact table that specifies the Unit that contact is a Resident of (think Building Management/Owners Assoc. type industry). Seeing as Business rules cant have other fields merged in when updating field values, I figure I need to use a flow or Dynamics workflow (but this is strictly a PowerApps question, so I have chosen Flow). Each time a contact record is added/modified and a record exists in the "Resident of Unit" lookup field. I want to update the contact's primary Address as follows: Unit 123 Chewie Street Address Line 2: adds2 info for chewie Address Line 3: adds3 info for chewie and so on.... I have tried multiple ways to select the data from the records that I need and added a condition that checks to see if a record exists for Address 1/Primary Address for the contact, if it does, it should update if it does not, it should create. Here's a screenshot of where I am at: I really don't understand why Dataverse in Flow needs to be this hard. Presumably youtube will remove any URL's to images that I put here. So if they have, I will get them to you another way. differentbitcomau-my.sharepoint.com/:i:/g/personal/bronson_differentbit_com_au/EYKxDvsHWPBNpd-gSvZ0J-UB84QmSq6LbSYJWrmq8oUXLw?e=d3ivNb differentbitcomau-my.sharepoint.com/:i:/g/personal/bronson_differentbit_com_au/ERGnAEcPwABOg8Patp5IEhkBG-_B4oEIgzrDSg83UnnRRw?e=KJLCxT Oh, if and when I find my solution, I shall update this comment. When I get around to adding it to the community also, I'll add a link to that too.
Know what? Calculated Column. DUH! - While that gets me out of the proverbial pickle jar this time, I still need to know and understand how to write to these damn columns with PA, AND will eventually need to write N:N (many to many) records with PA. In anticipation for that one!
Hi I have been trying for days to do something as basic as getting the list of child rows of an entity. I have an entity A with a one to many relationship with a table B that has details. The problem is when I do the Get list to the details table (B) filtering with the GUID of the parent in the Odata filter. I get a data type error and I can't solve it. Does anyone know how to do it?
Matt I think this video will help ruclips.net/video/BPkv7S11Zp8/видео.html In Power Apps you use the LookUp function to retrieve specific records. If you are asking for flow then you use "Get a Row by ID" action if you know the ID you want. If not use a "List Rows" action and use the Odata filter to specify your criteria
Shane these types of videos may not attract the most views but they are highly valuable. I am sure I could have figured this out but you saved me hours of work (and frustration).
Thanks William. I agree, this one I even rewatch if I need to do this. 🤪 It is hard and annoying.
I REALLY need to see Dataverse videos! Please keep them coming!
Noted. 🐶
Thanks Shane. I have been on the Dataverse/Powerapps journey for a few years now and there have been a few challenges that I dont think I would have gotten over if it wasn't for your videos. Just as you described at the beginning of this video, there are a few explanations on how to complete this task around, but none of them offer a definitive and repeatable process to achieve it. Your trick with the URL/API call provides the right result every time rather than guessing. In a flow in my case where I needed to write to multiple lookup fields at the same time, the error output is totally useless as it doesn't elaborate on which field is causing the error and increases the diagnostic time exponentially.
You are another member of this community that has brought me closer to my goals. I'll be sure to pay it forward.
Glad to help. 😀
Shane I can't thank you enough I stumbled upon your video by accident after countless hours of troubleshooting a dataverse issue even after finding a lot of blogs my issue wasn't listed but your video gave me the insight needed to finally finish my flow.
Thank you.
I think the more people understand about Dataverse the higher the demand will be. I'm really struggling to find resources to help me understand Dataverse and it's still very new and a lot of people haven't heard of it yet.
On another note...I really appreciate all the videos Shane you've transformed my life and career so THANK YOU!
Awesome. Glad to help. More Dataverse content is needed but isn't popular so hard to make too much of it. I am always trying to find that balance. :)
Thanks a lot Shane for another awesome video! I suggest another simpler trick to get the plural internal name without resorting to the API. In PowerAutomate, add a Dataverse action, select the table of your interest, and then peek code. You'll find its plural name right next to "entityName" :)
I didn’t know that. I will give it a look. Thanks. 😎
Thanks so much for this Shane. I was doing some development work during my holidays and this stumped me totally yesterday night. So then with much trepidation this morning, I did the magic URL incantation, found out the secret Entity Set Name word and placed in in that pesky lookup field. And it worked :)
Like how you took the time to research all the hidden nuts and bolts behind Data verse. Hopefully Microsoft gives you the due recognition because a lot of enterprise clients aren't using Dataverse because of the lack of knowledge. Your video helps demystify this and can help spur adoption.
This video saved my life
Doing God's work my man
Awesome. Glad to help
Two days and finally you saved me Shane Young thanks a lot. Dataverse lookup columns are sometimes crazy to handle.
Ran my Power Automate, wringing my hands waiting for the test to come back...and you nailed it! Thanks Shane.
Awesome Bill 😎
Subscribed and will be reviewing all your Dataverse vids... there is a large gap in what knowledge on this topic!
Thanks David 😎 I have more Dataverse planned this year. So much to cover and always evolving it seems.
Thanks! I've been looking for a workaround for the past three hours and finally saw your video, Man, you are a life saver.
Glad I could help
Thanks! I had about 20 tabs up of Microsoft docs and forum posts and didn't find this way to find the plural entity name..
I was looking in all the wrong places the whole time - finally got my first green checkmark after this video!! 🍻
Awesome 😎
Allways the same. Blocked on a triccky issue on PowerPlatform, looking for the solution for hours on Google and finally found a Shane Young video explaining everything I need to solve my issue. Thanks a lot, fun videos, very clear explainations, always learning something. Please, continue to make us progress on this techno!
I could kiss you right now for the frustration you have saved me! I have been trying to figure this thing out for days, thank you for explaining it quickly and efficiently!
You are welcome. 😊 The problem also drove me crazy.
We were watching a master doing his thing right there!!!! Thanks Shane!
Happy to help
Could not agree with you more Shane about how stupid HARD this is. I sure hope someone, if not several someone's over at MS are totally embarrassed at what a pain this is! (I wonder if it's this big a nightmare in Azure Logic Apps?!) THANK YOU THANK YOU THANK YOU for this video! I've been banging on this issue all dang day!
Glad to help Scott. 😀
Shane you are THE MAN!!! This was exactly what I was looking for to solve the same issue you had - spending hours trying to figure this out. Thank you, thank you thank you! I only needed to get to the 12 minute mark where you explain how to get the plural name of the lookup table and bingo! WOOOOHOOOOO....
Awesome Barry glad you got it working. I wish it wasn’t so difficult. 😬
This is now my Go To video for this way too convoluted process - Thanks Shane/Chewy
Awesome, we are both happy to help 🐶
Thank you Shane, ... If it is of any consolation, I had to view your video several times before thinking I understood ;-) . Thank you for your work. This is amazing that we call it low / no code, ... just to bulk upload a table containing lookup.
Thank you very much Shane the Young man. I have been spending all day sorting it out. You did it man, kudos champ.
Glad to help
Great tips Shane. I struggled myself to get these values and using the first function. More Dataverse please.
Got it. 😎
Thank thank thank! Nothing else left to say. (Came here after watching your video on how to save to Lookups within PowerApps, thanks for that as well.)
Glad to help. 😀
Wish I had found this video yesterday before I wasted my day. Excellent resource!
Thanks 😊
Thank you for this great video Shane. This is why is so important to create tables with singular names so we avoid that strange entity name. I think it's not sufficiently emphazised in the documentation. It says the following:
"Display name This is the singular name for the table that will be shown in the app. This can be changed later."
Good point
You are my hero! I was literally trying to figure this out and just put your name in front of the issue and boom, solution!
Awesome 🤩
Thanks, Shane! Your videos have always helped me!
Awesome, I am glad to help
You are a lifesaver, thank you for sharing. I had it close just didn't know about the / before the GUID. Been trying every combination.
Thanks Shane... Again you saved me like hours and hours. Watched this 4 times. Still figuring it out man.
Thanks a lot Shane for such an informative video. Just one point to add here is that for Dataverse(legacy) actions, it will be just GUID instead of the plural name and then GUID.
Thanks for sharing!
Just came across this bit of gold - Thank you!! I always struggle with this. Often, I'm able to use the OData Id, where I expect this method would also work (and using just the "unique identifier for the ..." does not work). Not sure if that Odata Id is a new thing since this video was created. It also doesn't always work, so I'm glad to have the right method.
The set name is now available to be copied directly from the properties view of the table in Dataverse rather than using the URL. Click the `Tools` drop drown and you will see an option to `Copy Set Name` 👍
Dude, you saved my ass big time. Thank you so much! ~ An anxious intern
Thank you Shane! Another day, another video to help solve my problem at work. :)
16:43....I wasted my whole day to figure out this.... That "es" ate up my whole day 🙃.. Thanks a lot Shane!! At last your video helped me as always......Thanks a million!! 😀
Such a hard problem to solve. Was happy to help. To be honest not sure I could do it again without rewatching. 😳
Thanks so much Shane, saved my day
Glad that it helped you 😎
Thank you, you saved me HOURS of figuring this out!
Glad I could help! This one was tricky.
Another great video Shane. Please please please make more Dataverse videos. fFor security reasons my employer only uses Dataverse. One idea: what are the pros and cons of using an auto number and/or the GUID in Dataverse. This is causing me pain at the moment. Thanks, Dave
Noted. Thanks Dave!
You have saved me big time !! Thank you so much for this precious tutorial.
Glad it helped!
Thanks Shane, this is an amazing video and thanks for not missing any steps!
Happy to help!
Needed this refresher today and you were there for me. Thanks dude.
Glad to help!
Thanks so much for this! That was way too difficult! Please keep the videos coming!
It is tough for sure. 😊
Man i can not thank you enough, even though this video is two years old, you pulled me out of my frustration. I just had to remove those damn single quotes xD
Happy to help. This stuff can be very frustrating. :)
Thank you sooo much for your great tutorial. I was desperately searching for a solution.... no where else, but you :D
Just wanted to let you know that you showed me that my cast to a lookup was supposed to be "systemusers" and not "systemuser". I hadn't used any plural names before so I had no idea. I was stuck on that for awhile, so thank you.
Just another time you save me hours of trying and failing. Thank you so much dude!
I find Dataverse useful because it allows me to reference views in Dataverse that have 2000 items or fewer in which is how I try to skirt delegation. (Please correct me if I’m wrong about that.) My point is that although it’s not as common as SharePoint, Dataverse is my go-to. I also find the way you can custom create query filter views from model driven apps is helpful. If I’m not sure of results returned from a canvas created expression I check it using the model driven Dataverse views. Bottom line, Dataverse can do more than SharePoint so more Dataverse is very much appreciated. Thank you.
This is awesome , Shane. Thank you for sharing with us.
You are welcome 🙏
Thanks Shane young you are amazing person i have learned many things from you and i will remember this on every moment of my life that you are providing me really hard core MS CRM Consultant Thhhhaaaannnnnnnnkkkkkssssss !!!!!! aaaaaaa LooTTTTTTTTT
Happy to help
Hi Shane - *definitely* keen to see more Dataverse videos - the primary data source isn't always Sharepoint...
Thanks Shane! 😊 I wish I found this video before I lost my entire Friday fighting with Dataverse/PA before giving up 😂
Sorry James make sure you subscribe and I will send it to your directly next time. 😜
@@ShanesCows Don't worry I have been subscribed for over a year now. I wouldn't want to miss a Chewy Barktastic Update! 🤣🤣🐶🐶
Wow, glad you worked that out. I'm just trying to finish a piece of customer work and hit this and thought wtf! Then found this ..phew
Glad to help
Hello Shane,
Thanks for your amazing videos !
Juste for some who will encoure an error ( Bad Request Error ) Try to put just the id of the lookup field that would be fine ( i faced this error and did that )
Sharing is caring
Thanks for sharing.
Great video man, I am heavily using Dataverse with Flows so more videos on this would be great. Especially when working with data from external sources like MS SQL ie Dataflows.
hi shane you are a life saver... I was struggling to fix this for hours.... well I have the exact reaction as your's....yyyyyyaaaaaaaaahhhhhhhhh 🙌
Glad to help. 😀 have a great weekend
Thanks, Shane. Very very useful. Kind regards, Robb
Thank you for all your good work.
My pleasure!
Thanks Shane, it was realy helpful for me .....bundle of thanks
Thanks, Shane! Your videos are always helpful! Any idea how the process would change if you inserted a new row that had two favorite toys (option set that allows multiple selections)?
Thanks for doing the homework!
That was a tough one! Well done 👍
This was a lifesaver - thankyou so much
Happy to help Alison. 😎
Man YOU ARE A SAVER!!!! thank you so much....
Happy to help. Have a great day. 🐶
Hey Shane! I'm really struggling with this - I have a Column in my table called, 'full name' which is a text column. In the same column I have a lookup called, 'system user'. I just want to copy the full name column into the lookup column to save me having to manually key in each one. I have 1000 rows of data and I cant seem to get this video to run the flow on each item to copy it over - please could you help?!
I'm doing this same scenario now... did you solve it?
Thanks Shane! This Compose function seems more trouble than it is worth though. Any harm in limiting the list rows to one row, and then keeping the For Each loop (which would only run on one record)?
Nope. If that works for you then go for it. :)
Thanks for the great video. I was trying to load data using a DataFlow, but it didn't allow me to write to a relationship lookup column. This video helped me get a Power Automate Flow working! I found that when Exporting data from a table, the CSV file that is downloaded is named with the table Plural name, at least for the ones I exported. I'm not sure if it will always hold true.
Thanks for sharing!
Great Video Shane...Helped a lot !!....I'm just stuck now for a choice column....can you do a video on that as well ?...it seems to be very hard to do
u just saved my job buddy that you and god bless you !!
Awesome! I am glad I could help. This video took me forever to learn so glad it saves others.
Thanks, very helpful. This thing shouldn't be this complicated
Agree!
Thanks!!!! You save me a lot of time! 😊
Happy to help. Have a great day. 🐶
You are really cool!
Your videos are awesome 😊
I learned a lot with all your videos
Thanks a lot 🙋🏻♂️
Happy to hear that!
Man, you are THE BEST!!!!!
Happy to help. Have a great day. 🐶
YES! More Dataverse please!!!
Thanks
Shane, can't seem to find the URL in the video description and chance it changed or is out of date? If not, could you please update the description?
This one? org7c481c88.crm.dynamics.com/api/data/v9.1/EntityDefinitions(LogicalName='cr662_chewystoys')?$select=EntitySetName
Great, Shane, thanks--Am wondering if this could be a workaround towards creating relationships while I wait to see if my org will turn on the PowerApps Office Add in. Since we don't have the Automate add-in either, probably not, so it would be challenging to get all the dimensions entered so there would GUID's to look up in the first place. But maybe initial data could go from Excel to a SharePoint list to a Flow to Dataverse...but for Teams? I did see "Premium" on the connectors you were using so not sure if this will for for Teams vs Pro. Ponder ponder....
I have used exactly this to import related data tables. So I think you are thinking the right way. 😎
@@ShanesCows Finally taking the plunge here, Shane! I tried Andrea Pinillos' approach during the dataflow stage to no avail (ruclips.net/video/SueC1d2xUNQ/видео.html) then gave a ForAll / Relate formula within an app one last try (using a 3rd data source so the ForAll wouldn't be operating on itself), and am now back to Power Automate. I think it might be easier with existing records using the "Relate Rows" Dataverse Power Automate function, but PA doesn't list my custom relationship, just some default ones, and it doesn't like when I enter it as a custom value, hmmmm.....
Hi Shane . Using your example, you can now use /cr622_chewytoyses/'_cr662_chewystoys_value' which gives you the GUID of the toy. This returns the Primary Name Column of the lookup table. So the format is /lookup table/'_lookup column name_value'. If you List Rows in Chewy's Toys, Chewy's Toy (Value) is available in the dynamic content of the Add new row section of your Flow.
Hi Paul, I'm very interested in your alternative expression. I failed to get the GUID with Shane expression: First(...?['chewystoysid'])). But if I type in directly the GUID retrieved from the Lookuptable Excel export then it works. ; /LookupPluralNametable(GUID) ;
If I type your expression as input of Favorite Toys(Chewy's Toys) I have a syntax Error.
It's amazing why it's so difficult to get dynamically a row GUID, while a few connectors ask for Row GUID input. I certainly missed something or the entire picture ;-)
As always, legend, cheers for this
Thanks Jon 🤩
Great video again Shane!
Could you consider a video on Dataverse Search Preview?
I don't know what that is but I will go looking around.
This is 2024. This RUclips Video is the only video that Google has to recommend. THIS VIDEO IS JUST WRONG. JUST AN FYI TO EVERYONE:
Step 1. Go to the Dataverse table you are using in the Lookup Column. Go to the Properties and Copy the "Logical name" of that table. Again.
Step 2. For reference we are here @13:20. PASTE the logical name in the Lookup Column box. for the example in the video it might look something like "new_systemuser"
Step 3. You need to put in the row ID of the thing you want. So the @7:22, where Shane is filtering his email.
Step 4. The end result in that lookup column should be similar to "new_systemuser(Outputs('Compose'))"
The video seems to work for everyone else. Sorry it doesn’t work for you. There are other ways to do it. Glad you found a method that works for you.
very nice video. Thank you ! I try to find a way to get dataverse choice column guid but cant find any info on line. Can you also give some direction on choice column? Thanks!
Hi Shane, how does it work f the data source is excel and destination Dataverse? Thank you
The Excel data would most likely just be text. So you would need to write logic to take your Excel Text value of "Red" and then find the correct record in Dataverse to map to. Not trivial but possible. Probably end up using an oData filter or lots of conditionals or a switch. Sorry, I don't have an exact video
Does this also work on virtual tables e.g., aaduser because always giving me an error related to syntax?
I am not sure, I haven't treid.
Thanks for the video 🙏🏻
My pleasure!
Is there still no way to fill the lookup column using an Alternate Key? Why does Dataverse allow setting keys for tables if we can't use them in Power Automate?
I have never tried with the alternative key but I doubt it 😐
Hi Shane, That was a great video. Thanks.
I'm wondering if you could help me out. I have a contact record that I've done another lookup to the contact table to add that users manager. I'm having trouble accessing the GUID of the lookup table. I thought this should be easy but everything I have tried has not returned anything.
Grazie grazie grazie grazie! You saved my life!
That is an annoying issue for sure!
Hi Shane awesome video!!!! Have you done a patch attachments to SharePoint?
I have done to a doc library. As far as I can tell it is not possible to patch an attachment. ruclips.net/video/3QaiM8SeWfM/видео.html
I keep getting an error in the add row step : ')' or ',' expected at position 4 in '(test-ID-4)'. test-ID-4 is the correct output of compose... what is happening? Thanks
I never comment but I have been racking my brain on this issue. I have a SPO list that I need to import nightly and in that list there is a lookup column. I need it to convert and get the name into the dataverse table. Running into a lot of issues. This is great if I KNEW what name would be picked every time but I don't :(
Taylor you have to build logic that dynamically deals with it. Maybe use a Switch action and then have a path for each column value you have. It sucks, but I don't have a magic bullet other than brute force.
Hi Shane.
Great video, thanks for your advice on this. I have a query which may take this one step further.... I have a flow where I am doing exactly what you have shown here, and inputting data into a lookup field using the plural of the entity list. That one is working well.
I have an additional field which is an "Expand Query", where I am pulling contact information from a related table, and it also needs to go into the target table also with a lookup field. The expression "create new row" expression which uses the output from an "Expand Query" appears to be different from what you have outlined here. Have you discovered the expression for this?
Thanks again.
Peter
You saved me! Legend!
Glad to help. This was a tricky one for me.
Amazing! Would never have figured that out
Thanks 😊
Hey Shane, LOOOOONG time fan, first time I think I have commented with a question though. (Just so you know, sometimes I set you to binge mode (eventually Ill need the info I figure haha).
Anyway, thanks for this video - when I watched it I wasn't really looking for a solution, but sure enough a couple of use cases have since come up. (I still struggle somewhat with the differences between all of the ID's and GUID's and row numbers etc when it comes to using them in Power Automate, clearly this is something that MS needs to unify or at least come up with some clear terminology for).
I know this video doesn't quite cover my exact situation (actually, this is the first of your videos I have actually struggled to get my head around the why's of doing it the way you have done it).
So I thought I would through this one at you while I go down the rabbit hole myself. Perhaps it would be a good topic/use case for a future video?
I have an N:Many relationship custom field added to my Contact table that specifies the Unit that contact is a Resident of (think Building Management/Owners Assoc. type industry).
Seeing as Business rules cant have other fields merged in when updating field values, I figure I need to use a flow or Dynamics workflow (but this is strictly a PowerApps question, so I have chosen Flow).
Each time a contact record is added/modified and a record exists in the "Resident of Unit" lookup field. I want to update the contact's primary Address as follows:
Unit 123 Chewie Street
Address Line 2: adds2 info for chewie
Address Line 3: adds3 info for chewie
and so on....
I have tried multiple ways to select the data from the records that I need and added a condition that checks to see if a record exists for Address 1/Primary Address for the contact, if it does, it should update if it does not, it should create.
Here's a screenshot of where I am at: I really don't understand why Dataverse in Flow needs to be this hard.
Presumably youtube will remove any URL's to images that I put here. So if they have, I will get them to you another way.
differentbitcomau-my.sharepoint.com/:i:/g/personal/bronson_differentbit_com_au/EYKxDvsHWPBNpd-gSvZ0J-UB84QmSq6LbSYJWrmq8oUXLw?e=d3ivNb
differentbitcomau-my.sharepoint.com/:i:/g/personal/bronson_differentbit_com_au/ERGnAEcPwABOg8Patp5IEhkBG-_B4oEIgzrDSg83UnnRRw?e=KJLCxT
Oh, if and when I find my solution, I shall update this comment. When I get around to adding it to the community also, I'll add a link to that too.
Know what? Calculated Column. DUH! - While that gets me out of the proverbial pickle jar this time, I still need to know and understand how to write to these damn columns with PA, AND will eventually need to write N:N (many to many) records with PA. In anticipation for that one!
Great Video Shane!
Any tricks or tips to handle Many-to-Many relationship scenarios?
Is there a method for this in Teams?
Very helpful, great work! Can you also kindly do a power automate between SQL server tables and Dataverse tables?
Yes, same concept. :)
Hi Shane, this was very helpful indeed, do you also have an answer how to do this for a Choice field?
I am also looking for the choice field option to do this,. Have you found anything to help?
@@maritheron3150 Hi Mari, I have note found a solution to this. Sorry.
Hi I have been trying for days to do something as basic as getting the list of child rows of an entity.
I have an entity A with a one to many relationship with a table B that has details. The problem is when I do the Get list to the details table (B) filtering with the GUID of the parent in the Odata filter.
I get a data type error and I can't solve it.
Does anyone know how to do it?
Thank you Shane!
you're amazing man
Appreciate it. This video is a life saver.
Thanks, it worked.
Awesome
How do you fetch from a table based on the first result of another fetch?
Matt I think this video will help ruclips.net/video/BPkv7S11Zp8/видео.html
In Power Apps you use the LookUp function to retrieve specific records.
If you are asking for flow then you use "Get a Row by ID" action if you know the ID you want. If not use a "List Rows" action and use the Odata filter to specify your criteria