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

Published: 02 December 2022
on channel: Bright Ideas Agency
11,944
108

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.


Watch video How To: Work with Dataverse Lookup columns in Power Automate flows online without registration, duration hours minute second in high quality. This video was added by user Bright Ideas Agency 02 December 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 11,94 once and liked it 10 people.