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

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

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.



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


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