How To: Work with Dataverse Lookup columns in Power Automate flows

Need an AI plan for your business? Check out Nick's new book, "Who's in the Copilot's Seat?" - https://brightideasagency.com/book - And if you need more personalized help or advice, check out new engagement options that are available too - https://brightideasagency.com/engage In this video, we'll show you how to work with Dataverse lookup columns in Power Automate flows. Power Automate is a great tool for automating your business processes. In this video, we'll show you how to use Dataverse lookup columns in Power Automate flows to automate your work. We'll give you a demo of how to use lookup columns to extract data from Dataverse tables and put it into the appropriate fields in your flows. After watching this video, you'll be able to use lookup columns in your flows to automate your work! Chapters: 0:00 Introduction 0:43 Set-up of Dataverse tables 1:21 List Rows in Power Automate 2:38 Get data from related Dataverse tables 4:25 Using expand query option to get data from related Dataverse tables 6:10 Use $select statement in expand query to select related table columns 7:05 Add a row that includes a lookup column 9:15 Conclusion Apart from publicly accessible information all user data or other related information shared in this video is created for demonstration purposes only. User accounts, passwords, or other data used as part of any demonstrations shown in this video have been created specifically for that purpose and are not any individual or company's private information or data. Bright Ideas Agency is an Ohio Limited Liability Company. The content of this video is for informational and entertainment purposes only. No guarantees are given in connection with the information shared and you should seek independent technical or business advice before implementing anything you see in this video. If you want to hire us for your project, visit https://www.brightideasagency.com and get in touch.