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 666
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

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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