Background

As we all know, in Logic App Standard with WS ASP, we follow the target-based scaling as Azure Function EP plan which mostly depends on job queue length not CPU/memory usage.

But in some situations, we could experience high CPU/memory usage without a long job queue which results to the scale controller cannot vote to increase backend instances as expected.

So this blog is introduce how to “simulate” rule based scaling feature for Logic App Standard with WS plan as Logic App Standard running in ASE via using Logic App Consumption (it can be out Azure products as well, eg: Azure Function).

Mechanism

Since we need to scale based on CPU/memory usage (can be different metrics as well) , so the first issue we need to resolved is to get metrics data as following:

For example, if we would like to get average CPU usage, we can go into CPU Percentage page and capture a HAR trace which can tell us that the API used in portal is like:

https://management.azure.com/subscriptions/[SubscriptionID]/resourceGroups/[ResourceGroup]/providers/Microsoft.Web/serverFarms/[ASP Name]/providers/microsoft.Insights/metrics?timespan=[StartTime]/[EndTime]&interval=PT1M&metricnames=CpuPercentage&aggregation=average&metricNamespace=microsoft.web%2Fserverfarms&autoadjusttimegrain=true&validatedimensions=false&api-version=2019-07-01

Once we have the CPU usage data, we can calculate to see whether the current value hit the threshold, if so, we can call management API to change always ready instance count (Web Apps – Update Configuration – REST API (Azure App Service) | Microsoft Learn).

Implementation Logic

1. Retrieve CPU usage via API for past 2 minutes and calculate average

2. Retrieve current Logic App backend instance count and set target instance count as current

3. Validate when average CPU usage hit scale in/out threshold (>50% or <10%)

If larger than scale out threshold, add 1 instance in target instance count if not hit maximum (20) instance count
If less than scale in threshold, remove 1 instance in target instance count if not hit minimum (1) instance count

4. Compare current and target value, if it is different, then send request to change always ready instance(s).

Sample Template

Demo can be found in Drac-Zhang/Rule_Based_Scaling_Template (github.com) which implemented the scaling feature based on CPU usage of past 2 minutes.

Meanwhile, for the Logic App Consumption, we need to enable Managed Identity, assign “Reader” and “Logic App Standard Contributor” role on resource group level for MI.

Known Issues

1. Since it is monitoring the CPU/memory usage on ASP level, so for the ASP, it only can have one Logic App, but this can be workaround via change metrics call to Logic App specific CPU/memory usage.

2. The Logic App Standard configuration API changes always ready instance, the maximum value is 20 as per current WS plan.

3. We have around 1 minute latency for retrieving metrics due to ingestion delay.

​Microsoft Tech Community – Latest Blogs –Read More 

In this article, I’ll demonstrate how to build a Power Apps canvas application from within SharePoint that integrates a SharePoint list backend for storing and retrieving images and audio files. The app that you create will have labels, icons, navigation, image containers, and other elements. You’ll use a layout template and customize the built-in audio control to have a distinct appearance and behavior.

By following the step-by-step instructions in this article, you will be able to create a powerful and fully functional canvas application that’s integrated with SharePoint. By using SharePoint lists for storing and retrieving images and audio files, you can ensure that your app is efficient and easy to manage. The customization options available through Power Apps make it possible to create a unique and visually appealing user interface that’s tailored to your needs. Additionally, you can customize the built-in audio control for a distinct appearance and behavior that will enhance the user experience. With the help of this article, you can create an application that’s sure to impress and provide a valuable tool for your organization.

User Interface of the Power Audio Player fully SharePoint integrated.

To begin, you need to have:

A Microsoft 365 license or Microsoft 365 developer account.
A basic understanding about SharePoint (site, list and document library) and Power Apps development.

The high-level sequence of tasks is as follows:

Create elements in SharePoint.
Design and configure the application interface and controls in Power Apps.

Creating a Track List, Picture Library, and Document Library in SharePoint

First, you’ll build the elements in SharePoint.

Step 1: Build the Track List in SharePoint List

In the track list, you’ll create columns for title, artist, artwork, and audio file, where you will add associated data.

Open SharePoint, and then create a new SharePoint site or use an existing site.
Create a new list with the following sample columns (Title, Artist, Artwork, AudioFile), as shown:

Creating a track list with columns.

The list columns have the following associated data types:

Title – Text
Artist – Text
Artwork – Image
Audio file link – Multiple lines of text

You’ve now created the track list with data. Next, you’ll create the picture library.

Step 2: Create the SharePoint Picture Library to Hold Your Images

Create a picture library to hold all your audio image covers.

To do this, navigate to the site where you want to create the picture library. Select Settings, and then select Add an app. If you don’t see Add an app, select Site contents, and then select Add an app, as shown:

Adding an app. Source: support.microsoft.com

On the Your Apps page, enter Picture into the search box, or select Picture Library. Then in New, select Advanced Options. In Name, enter a name for the library. The library name is required. Enter a description of the library (this is optional), and then choose whether to create a version each time you edit a file in the picture library.

Entering a name and description for the picture library.

Select Create. The name of the picture library appears under Recent in the Quick Launch panel.

Name of the picture library appears in Quick Launch.

Step 3: Create a SharePoint Document Library to Hold Audio Files

This is the final development stage in SharePoint, where you will create a placeholder for storing image files in SharePoint. In your SharePoint site, select New > Document library > Create (after naming it), as shown in the following video demo.

Video 1: Demonstrates how to create a SharePoint document library.

Developing the Power Apps Application

You can use Power Apps to build custom apps for business scenarios such as data collection, data management, and data visualization, without having to write complex code.

At this point, you’ll develop the Power Apps application UI to feed on the data that you created in SharePoint. Although you could visit make.powerapps.com to start a new blank canvas app and connect to SharePoint to build the app for you, you’ve now integrated this data into a SharePoint list.

Open your track list.
Select Integrate > Power Apps > Create an app (figure 5).
Enter a name for your app, and then select Create.

Creating an app.

Designing the Application Controls

Once you’ve generated the app from your SharePoint list, you will construct the interface and configure the controls within the app.

Step 1: Configure and Design the Track List Screen – First Screen

Modify the background properties of the application, and then update the style of the artist image cover to have a circular shape.

To change the background image in PowerApps:

In Power Apps Studio, select the screen.
In the right-hand pane, go to Properties.
From the background image dropdown options, select Add an image file.
Browse to the file you want to use, and then select Open.

To make the image control have a circular shape:

Select the image control that has the artist album cover.
In the right-hand pane, select the Properties tab, if not selected.
Change the Border radius properties to 360.

The aspect ratio of the image will be preserved. If the image isn’t square, it may appear distorted in the circular shape. 

Example of a track list screen

Step 2: Build the Play Screen – Second Screen

Now you’ll create the play screen, which includes various controls and displays whatever track is playing. After you’ve built the screen, establish a connection between the first screen (the track list screen) and the play screen. Once you’ve connected the screens, you can navigate, when a track is selected.

To do this:

Go to the first screen (track list screen).
Select the first track, and update its OnSelect property to Navigate(PlayScreen,ScreenTransition.CoverRight). This will navigate the screen to the play screen when you select it.

Build the second screen (play screen) by adding the image control from the selected track:

From the Insert tab, add an image control.
To set the image in your gallery image from the SharePoint database, you can update the image function by using the provided sample code: SongGallery.Selected.Artwork. This is based on what I have. Yours might be a different name.

The Selected property in PowerApps references a currently selected item in a gallery, form, or data table. The SongGallery.Selected refers to a currently selected item in the SongGallery gallery.

The Artwork in this formula is the name of the field that contains the image of the artwork in the data source used by the SongGallery gallery. This field is the column in a SharePoint list that has the track title.

Therefore, SongGallery.Selected.Artwork refers to the image of the artwork that’s associated with the currently selected item in the SongGallery gallery. It enables you to display the artwork in an image control or perform other actions with it.

After making all the necessary editing, the screenshot below shows how your image should look. 

Example of a play screen.

Add the Text Labels

On the Insert tab, add two text labels.

Just like the previous updates that you made on the image preview of the selected track, you will apply similar code here to view the artist name and the track title.

Set the text function of one of the text labels to SongGallery.Selected.Title. The Title in this formula is the name of the field that contains the title of the item in the data source that the SongGallery gallery uses. This field is the column in a SharePoint list that has the track title.
Set the second text label function to SongGallery.Selected.Artist. 

Add the Audio Control

This is the control that will play the selected track from the previous screen.

From the Insert tab under Media, add an audio Control.
Update its Media function with First(SongGallery.Selected.Attachments).AbsoluteUri. This will enable the audio player to play the selected track.
The following is similar to earlier code, except:

The First function is used to return the first attachment in the attachments collection associated with the currently selected item in the SongGallery gallery.
The AbsoluteUri is a property of the attachment object that returns the URL of the attachment. First(SongGallery.Selected.Attachments).AbsoluteUri is a reference to the URL of the first attachment associated with the currently selected item in the SongGallery gallery, which enables you to display or download the attachment or perform other actions with it.

Change the visibility of the control to False. This is to hide it from showing, since new controls will be created.
Enter the variable varStarPos into the StartTime function.
Enter varPlayinto the Start function.

Adding the audio control.

Add the Slide Bar, Forward, Backward, Play, and Pause Buttons

You will need to add a slide bar and four image controls. You can find these on the Insert tab. After you’ve added them, update each control as follows.

Update the image of the button by browsing an image from your system through the image property of the image control on the Properties tab in the right-hand pane.

Uploading a custom image control.

Slide Bar:

You can use the slide bar to fast-forward or rewind the currently playing audio.

Update the OnSelect function to Set(varStarPos, Self.Value). Here you’re setting a variable called varStarPos that you used in the StartTime function of the audio control.
Update the Max function to Audio1.Duration. Audio1 is the default name of the audio control.
Set the Default function to varStarPos. This is the default position of the slide bar.

Adding a slide bar.

Forward Button:

Update the OnSelect function of the button with the following:

Set(varStarPos,Audio1.Time – 2);

Set(varPlay, false);

Set(varPlay, true);

Backward Button:

Update the OnSelect function of the button with the following:

Set(varStarPos,Audio1.Time + 2);

Set(varPlay, false);

Set(varPlay, true);

Play Button:

Update with the following:

Update the OnSelect function to Set(varPlay,true).
Set its Visible function to !varPlay. The button should not be visible when the audio is playing.

Pause Button:

Update with the following:

Update the OnSelect function to Set(varPlay,false).
Set its Visible function to varPlay. The button should be visible when the audio is playing.

Place the play button on the pause button. The visibility function will make one appear and disappear based on the audio.

The resulting app interface for the play screen (second screen).

App interface for the play screen.

Step 3: Build the Add Track Screen – Third Screen

Because you created the app from a SharePoint list, the screen has already been generated for you. You can update the interface by using the available properties.

Step 4: View the Completed App Screens

And there you have it! Don’t forget to add a sound bar .gif file on the screen to display.

Resulting app screen.

Summary

We learned how to build an audio player in Power Apps with a track list integrated from SharePoint. We started by creating a track list, picture library, and document library in SharePoint, and then used Power Apps to design and configure the application controls.

With this audio player, users can easily browse through the track list, select a track to play, and even pause or skip tracks. The user interface is sleek and intuitive, allowing for a seamless experience for users of all skill levels. The integration of SharePoint and Power Apps makes it possible to store and manage the audio files, in addition to any related pictures and documents, all in one central location. This not only improves organization and accessibility but also ensures that the latest versions of files are always available to users. The possibilities for customization and expansion of this audio player are endless, making it a valuable addition to anyone’s digital toolkit.

Resources

SharePoint documentation

SharePoint community

Microsoft Power Apps documentation

Power Apps community

Power Apps YouTube channel

Power Apps on Microsoft Learn

​Microsoft Tech Community – Latest Blogs –Read More 

Hi, I’m having an issue with OneDrive – if I attempt to share a file and generate a link that can be opened by anyone and then send that link out, anyone who tries to open the link receives a “404 NOT FOUND” page.  This happens for any file in my OneDrive account.  I can simulate this if I copy the link and then try to open the link in an incognito or private browser where I am not signed into my OneDrive account.  The permissions on the file are set to “anyone with the link can edit”.  Can anyone help?

​Hi, I’m having an issue with OneDrive – if I attempt to share a file and generate a link that can be opened by anyone and then send that link out, anyone who tries to open the link receives a “404 NOT FOUND” page.  This happens for any file in my OneDrive account.  I can simulate this if I copy the link and then try to open the link in an incognito or private browser where I am not signed into my OneDrive account.  The permissions on the file are set to “anyone with the link can edit”.  Can anyone help?    Read More

​