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.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9.
Early bird rate extended! Save $200 when you sign up by March 31.
Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning and boost your career prospects.