Use a Power App app with Power Platform connector having an SAS Viya REST API endpoint (part3)

[#1]

Introduction

In part1 of this series we created a customer connector via the Microsoft Power Automate platform (part1). We continued this series with a part2 where we created Power Automate Flow consuming the customer connector from part1.  Now let's integrate this Power Automate Flow in a Power App and demonstrate how SAS Viya REST endpoints can be consumed in our customer business applications.

Create a Power App

Go to https://powerapps.com/.

Let's start by creating an empty app.

You can start with adding Text labels:

After you can add 2 Text input fields next to each label. Make sure you switch format to Number.

To make next step easier change the name of those 2 input fields to 'limit' and 'start':

As next step add a button and label as you want.

t's now time to add the Power Automate flow we created. Click on the Power Automate and from there you can add your flow:

Now change the Function of the 'Fetch Rows' button to:

Then drag and drop the 'Data table (preview)' from the Layout section to the canvas:

Make sure you select the table you referenced in the function of the button. If you followed the example it should be 'tbl'. After that you can click 'Edit fields'

There you can click 'Add field' and select any number of fields that are returned by the PowerAutomate flow.

You should be able to preview the app.