BookmarkSubscribeRSS Feed

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

Started ‎08-29-2023 by
Modified ‎08-29-2023 by
Views 844
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.

 

image42.png

image43.png

You can start with adding Text labels:

 

image44.png

 

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

 

image45.png

 

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

 

image45_b.png

 

image45_c.png

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

 

image46.png

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:

 

image47.png

 

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

 

image48.png

 

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

 

image49.png

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'

 

image50.png

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

 

image51.pngimage52.png

You should be able to preview the app.

 

image53.png

Version history
Last update:
‎08-29-2023 10:09 AM
Updated by:
Contributors

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

Free course: Data Literacy Essentials

Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning  and boost your career prospects.

Get Started

Article Labels
Article Tags