Query External Database

Last modified: February 29, 2024

1 Introduction

The Query External Database activity is used with the External Database Connector to use preconfigured database queries and display retrieved data in your app.

This document covers the properties of the Query External Database activity.

To learn how to use this activity in a microflow and configure other aspects of the Database connector, see the Configuration section of External Database Connector.

2 Properties

Double-click the Query External Database activity to view its properties.

In the Query section are the following properties:

  • Database – the name of the database you want to query
  • Query – the saved SQL query from your configuration of the Database connector
  • Parameters – the saved parameters from your configuration of the Database connector

In the Output section are the following properties:

  • Return type – the return type once the microflow is completed
  • Use return value – select Yes or No
    • List name – if Use return value is set to Yes, this is the name of the returned list