Retrieving data using available connectors

Using a Power Automate flow leverages a large set of available connectors to tap into external systems or data sources and retrieve various pieces of data to be returned to the conversation. There is a large number of available connectors, some created by Microsoft and others created by various vendors. If you cannot find an existing connector for your respective data source, you can always create a new custom connector. Depending on the data source, this could be either a simple configurable process, or it might require some more advanced custom coding.

In our example, we will use an existing Microsoft-provided connector to retrieve data from Dynamics 365 Sales and return to the conversation a set of active opportunity records. You can take a similar approach for any other tables in Dataverse, including standard tables such as Account or Contact if you are not using Dynamics 365 Sales. This example is a common scenario for organizations...