Build an app to retrieve Power Platform videos for readiness
In this tutorial, you’ll build a solution that retrieves, lists, and displays content that can be used for readiness.

Objective
The focus of this tutorial will be on finding, retrieving, browsing, and playing video content available on YouTube or RSS Feeds with MP4 video files. It will continually monitor these channels and feeds for new content, and send a message to a specified Microsoft Team when new content is available.
The channels and feeds in the tutorial will focus on Power Platform content but can easily be used for other topics.
In this tutorial, you’ll use:
- Power Apps to build the application to specify the YouTube channels and RSS feeds.
- Power Automate to retrieve information about new and existing videos.
- Microsoft Dataverse for Teams to create tables to store the feed and video information.
- Power Automate to send a message to Microsoft Teams when a new video is delivered.
Prerequisites
Identify an existing Microsoft Team or create a new Microsoft Team that you’ll build your app for.
Identify an existing channel or create a new channel within Microsoft Teams to post the messages sent, to specify that a new video has been retrieved.
If you’re unfamiliar with how to create a Team or a channel in a Team, see Create a channel in Teams.
In this tutorial, we'll use a channel named "Readiness".
Step 1: Install and pin Power Apps in Teams
In this section, you’ll install the Power Apps app in Teams and pin it to the left rail so you can easily access it. To learn how to do install and pin the Power Apps app, see Install the Power Apps personal app in Microsoft Teams.
If you’ve already done installed and pinned the Power Apps app, you can skip to the next step.
Step 2: Create the app and the tables
In this section, you’ll take the initial steps to create the application.
Select the Power Apps app.
Select the Build tab at the top of the screen.
Select Create shown in the lower left of the screen.
This action will display the Create an app dialog box.
Select the name of the team from the drop-down list and select Create.

Note
If this is the first time you’ve tried to create an app in this Microsoft Teams team, it will take a moment to set up.
When prompted for the name of the app, enter Video Library and select Save.
Step 2.1: Create the table for the feeds
In this section, you'll create a table to store the names and details for the feeds that will be used by the application.
Select Create new table on the left side of the screen.
When prompted for the name of the table, enter Feeds.
Select Create.
Step 2.1.1: Edit the Name column
In the visual editor, select the drop-down menu for the Name column and then Edit column.
Change the name to Title.
Select Advanced options and then change the value for Max length to 255.
Select Save.
Step 2.1.2: Create the Description column
Select + to create a new column.
Specify the name as Description.
For Type, select Text from the list.
Select Advanced options and then change the value for Max length to 255.
Select Create.
Step 2.1.3: Create the Image Link column
Select + to create a new column.
Specify the name as Image Link.
For Type, select URL from the list.
Select Advanced options and then change the value for Max length to 255.
Select Create.
Step 2.1.4: Create the Image Title column
Select + to create a new column.
Specify the name as Image Title.
For Type, select Text from the list.
Select Advanced options and then change the value for Max length to 255.
Select Create.
Step 2.1.5: Create the Last Retrieved column
Select + to create a new column.
Specify the name as Last Retrieved.
For Type, select Text from the list.
Select Create.
Step 2.1.6: Create the Link column
Select + to create a new column.
Specify the name as Link.
For Type, select URL from the list.
Select Advanced options and then change the value for Max length to 255.
Select Create.
Step 2.1.7: Create the Published On column
Select + to create a new column.
Specify the name as Published On.
For Type, select Text from the list.
Select Create
Step 2.1.8: Add a row
In the visual editor, add a row for the Microsoft show "#LessCodeMorePower" that will be used in testing.
| Title | #LessCodeMorePower (HD) - Channel 9 |
|---|---|
| Description | The show all about Power Apps. Learn more here! |
| Image Link | https://sec.ch9.ms/content/feedimage.png |
| Image Title | #LessCodeMorePower (HD) - Channel 9 |
| Link | https://s.ch9.ms/Shows/Less-Code-More-Power/feed/mp4high |
Note
Leave the Published On column empty.
The visual editor should resemble the image below.

Select Close to close the visual editor.
The screen created automatically in the app, named Screen1, should automatically bind to the table, displaying the fields in the table and the record you added.
The screen should resemble the image below.

Step 2.2: Create the table for the feed items
In this section, you'll create a table to store the details for the videos stored in the Feed Items for the YouTube channel or RSS feed.
Select Add data on the left side of the screen.
Select Create new table.

When prompted for the name of the table, enter Feed Items.
Step 2.2.1: Edit the Name column
In the visual editor, select the drop-down for the Name column, and then select Edit column.
Change the name to Feed Item ID.
Select Advanced options and then change the value for Max length to 255.
Select Save.
Step 2.2.2: Create the Feed column
Select + to create a new column.
Specify the name as Feed.
For Type, select Lookup from the list.
For the table, select Feeds from the list
Select Create.
Step 2.2.3: Create the Title column
Select + to create a new column.
Specify the name as Title.
For Type, select Text from the list.
Select Advanced options and then change the value for Max length to 255.
Select Create.
Step 2.2.4: Create the Description column
Select + to create a new column.
Specify the name as Description.
For Type, select Text from the list.
Select Advanced options and then change the value for Max length to 2500.
Select Create.
Step 2.2.5: Create the Primary Feed Link column
Select + to create a new column.
Specify the name as Primary Feed Link.
For Type, select URL from the list.
Select Advanced options and then change the value for Max length to 255.
Select Create.
Step 2.2.6: Create the Video Link column
Select + to create a new column.
Specify the name as Video Link.
For Type, select URL from the list.
Select Advanced options and then change the value for Max length to 255.
Select Create.
Step 2.2.7: Create the Published On column
Select + to create a new column.
Specify the name as Published On
For Type, select Text from the list.
Select Create.
The visual editor should resemble the image below.

Select Close to close the visual editor.
Now that you’ve created the required tables, select Save on the upper-right corner to save the app and close the Power Apps Studio.
Step 3: Create flows to get the video details for configured feeds
In this section, you'll create flows in Power Automate to retrieve videos for each of the configured feeds. This flow will monitor the RSS feeds for the addition of new videos, retrieve details for the videos, and save those details in the database.
When you’ve completed this section, your flow should resemble the diagram below.

Note
Power Automate has a trigger that allows you to detect when a new item is added to a feed for an individual feed. When tracking multiple feeds, this would require multiple feeds and would require the same number of flows to match the number of feeds. The approach taken in this lab is more complex but with the benefit of having a single flow that supports any number of configured feeds in a single flow.
Step 3.1: Create the flow
Select the Build tab.
From the list on the left, select the name of your team in which you created the tables earlier.
Select See all under the Built by this Team tab.
Select New.
Select Flow > Scheduled.

In the Build a scheduled flow dialog,
Enter the name as "Retrieve Videos".
Select Day as the frequency.
Select Create.

Step 3.2: Add the initialize variable action
Select New step.
Enter Initialize variable in the search box.
Select the Initialize variable action.
Enter Link to Video in the Name field.
Select String in the drop-down for Type.

Note
Don’t enter any value in the Value field.
Step 3.3: Add the List Records action
Select New Step.
Enter Microsoft Dataverse in the search box and select the action named List records.
Select Feeds in the Entity name property.
Select ellipsis (…) in the header of the action and select Rename.
Rename the action to Get list of feeds to retrieve.

Step 3.4: Add the Current time action
Select New Step.
Enter Date Time in the search box and select the action named Current time.

Step 3.5: Add the Apply to each action
Select New Step.
Enter Apply to each in the search box, and then select the action named Apply to each.
Select the text box under Select output from previous steps.
In the Dynamic content list, scroll down to the section Get list of feeds to retrieve, and then select value.
Select ellipsis (…) in the header of the action and select Rename.
Rename the action to Loop through each of the feeds in the database.

Step 3.6: Add the List all RSS Feed Items action
Select Add an action.
Enter RSS in the search box and select the action called List all RSS feed items.
Select the box for the property The RSS feed URL.
In the Dynamic content, scroll down to the section Get list of feeds to retrieve, and then select Link.
Select in the box for the property since and select Last Retrieved.

Step 3.7: Add the Apply to Each Action
Select Add an action.
Enter Apply to each in the search box and select the action named Apply to each.
Select the text box under Select output from previous steps.
In the Dynamic content list, scroll down to the section called List all RSS feed items, and then select body.
Select ellipsis (…) in the header of the action, and then select Rename.
Rename the action to Loop through each of the items in the feed since last retrieved.

Step 3.8: Add the Apply to Each action
Select Add an action inside Loop through each of the items in the feed since last retrieved.
Enter Apply to each in the search box and select the action named Apply to each.
Select the text box under Select output from previous steps.
In the Dynamic content list, scroll down to the section List all RSS feed items, and then select Feed links.
Select ellipsis (…) in the head of the action, and then select Rename.
Rename the action to Evaluate links to determine if this is YouTube or a Vlog with a video.

Step 3.9: Add the Condition action
Select Add an action.
Enter Condition in the search box, and then select the action named Condition.
Select the text box containing text Choose a value.
In the Dynamic content list that is displayed, scroll down to the section called Evaluate links to determine if this is YouTube or a Vlog with a video, and then select Current item.
Select the drop-down that shows is equal to, and then select contains.
Select the text box text Choose a value and enter the value .mp4.
Select ellipsis (…) in the header of the action, and then select Rename.
Rename the action to Check to see if there is a link with an MP4 file.

In the If yes path on the left, select Add an action.
Enter Set variable in the search box, and then select the action named Set Variable.
Select Link to Video in the drop-down for the Name property.
Select the textbox for the Value property.
In the Dynamic content list, scroll down to the section called Evaluate links to determine if this is YouTube or a Vlog with a video and select Current item.
Select ellipsis (…) in the header of the action, and then select Rename
Rename the action to Specify the Video Link is the link to an MP4 File.

In the If No path on the left, select Add an action.
Enter Set variable in the search box, and then select the action named Set Variable.
Select Video Link in the drop-down for the Name property.
Select the textbox for the Value property.
In the Dynamic content list, scroll down to the section List all RSS feed items, and then select Primary feed link.
Select ellipsis (…) in the header of the action, and then select Rename.
Rename the action to Specify the Video Link is the Primary feed link.

Select the header of the action to show the title of Evaluate links to determine if this is YouTube or a Vlog with a video.

Step 3.10: Add the Create a New Record action
Inside Loop through each of the items in the feed since last retrieved action, select Add an action.
Enter Microsoft Dataverse in the search box, and then select the action called Create a new record.
Select Feed Items in the Entity name property.
In the Dynamic content list scroll down to the section List all RSS feed items, and then select Feed ID.
Select the textbox next to Field Item ID.
Select Show advanced options link in the action to display all the fields in the table.
Select the textbox next to Description.
In the Dynamic content list, scroll down to the section called List all RSS feed items and select Feed summary.
Select the textbox next to Feed (Feeds).
In the Dynamic content list, scroll down to the section Get list of feeds to retrieve, and then select OData Id.
Select the textbox next to Primary Feed Link.
In the Dynamic content list scroll down to the section List all RSS feed items, and then select Primary feed link.
Select the textbox next to Published On.
In the Dynamic content list, scroll down to the section List all RSS feed items, and then select Feed published on.
Select the textbox next to Title.
In the Dynamic content list, scroll down to the section List all RSS feed items, and then select Feed title.
Select the textbox next to Video Link.
In the Dynamic content list, scroll down to the section Variables, and then select Link to Video.

Step 3.11: Add the Set Variable action
Select Add action after Create new record.
Enter Teams in the search box, and then select the Post a message (V3) (preview) action.
In the drop-down for the Team property, select the team to send the message.
In the drop-down for the Channel property, select the channel to send the message.
Select Show advanced options link.
In the Message property, create a message with details about the item. An example message is shown in the image below.

Select the header of the action to show the title of Loop through each of the items since last retrieved.
Step 3.12: Add the Update Record action
Inside Loop through each of the feeds in the database action, select Add an action.
Enter Microsoft Dataverse in the search box, and then select the action Update a record.
Select Feeds for the Entity Name.
Select textbox next to Item ID.
In the Dynamic content list, scroll down to the section Get list of feeds to retrieve, and then select Feeds.
Select textbox next to Title.
In the Dynamic content list, scroll down to the section Get list of feeds to retrieve, and then select Title.
Select Show advanced options link in the action to display all the fields in the table.
Select textbox next to Description.
In the Dynamic content list, scroll down to the section Get list of feeds to retrieve, and then select Description.
Select textbox next to Image Link.
In the Dynamic content list, scroll down to the section Get list of feeds to retrieve, and then select Image Link.
Select textbox next to Image Title.
In the Dynamic content list, scroll down to the section Get list of feeds to retrieve, and then select Image Title.
Select textbox next to Last Retrieved.
In the Dynamic content list, scroll down to the section Current time and select Current time.
Select textbox next to Link.
In the Dynamic content list, scroll down to the section Get list of feeds to retrieve, and then select Link
Select textbox next to Published On.
In Dynamic content list, scroll down to the section Get list of feeds to retrieve, and then select Published On.

Your complete flow should look like the following image:

Step 3.13: Save the Flow
From the upper-right side of the screen, select Save.
Select the back arrow in the upper left.
Select the flow Retrieve Videos.
Select Run in the command bar.
From the panel on the right side of the screen, select Run flow.
Select Done.
Select the refresh button in 28-day run history to show the details of the flow run.

If the flow doesn't show as succeeded, select Run and it will display the failed action with any associated error message.
Step 4: Edit the app to add the video library interface
In this section, you'll create a new screen in the app that enables you and other members of the team to browse through videos, see the video details, and play them directly within Teams.
To start editing the app:
Select Power Apps from the left rail in Teams.
Select the Build tab.
From the left pane, select the team environment where the app is created.
Under Built by this team*, select the Video Library app.
Now create a new screen and configure the screen controls using the following steps.
Step 4.1: Create new screen
Select Tree view.
Select New screen.
Select Blank layout.
Select + to begin adding controls to screen.
Step 4.2: Add the header
Enter Rectangle in the search box.
Drag the rectangle control onto the screen.
Set the following properties with these values:
Property Value X 0 Y 0 Width 1365 Height 60 Color Purple
Step 4.3: Add the header label
Enter Label in the search box.
Drag the label onto the screen.
Set the following properties with these values:
Property Value Text Video Library Display Mode View Font size 24 X 576 Y 0 Width 191 Height 61 Color White
Step 4.4: Add a rectangle for the Video List Header
Enter Rectangle in the search box.
Drag the rectangle control onto the screen.
Set the following properties with these values:
Property Value X 0 Y 61 Width 1365 Height 58 Color Purple
Step 4.5: Add a label for the Video List Header
Enter Label in the search box.
Drag the label onto the screen.
Set the following properties with these values:
Property Value Text Select a video from the list below Display Mode View Font size 14 X 39 Y 74 Width 320 Height 32 Color White
Step 4.6: Add a Vertical Gallery
Enter Vertical Gallery in the search box.
Drag the label onto the screen.
Set the following properties with these values:
Property Value Name Video Library Data Source Feed Items Layout Image, title, and subtitle X 0 Y 119 Width 450 Height 649
In the tree view on the left side of the screen, there are three controls underneath the Video Gallery with names starting with Subtitle, Title, and Image.

Step 4.6.1: Set the Subtitle
Select the control that starts with Subtitle.
Select the Text property from the property list on top-left.
Update the property value to the following formula:
ThisItem.Feed.Description
Step 4.6.2: Set the Title
Select the control that starts with Title.
Select the Text property from the property list on top-left.
Update the property value to the following formula:
ThisItem.Feed.Title
Step 4.6.3: Set the Image
Select the control that starts with Image.
Select the Text property from the property list on top-left.
Update the property value to the following formula:
ThisItem.Feed.'Image Link'
Step 4.7: Add the background for the feed item
Enter Rectangle in the search box.
Drag the rectangle control onto the screen.
Set the following properties with these values:
Property Value X 451 Y 61 Width 915 Height 707 Color Purple
Step 4.8: Add the feed item title header label
Enter Label in the search box.
Drag the label onto the screen.
Set the following properties with these values:
Property Value Font size 18 X 466 Y 51 Width 883 Height 78 Color White Select the Text property from the property list on top-left.
Set the Text property value to the following formula:
'Video Library'.Selected.Title
Step 4.9: Add a Video Control
Enter Video in the search box.
Drag the video control onto the screen.
Set the following properties with these values:
Property Value X 450 Y 129 Width 916 Height 523 Select the Media property from the property list on top-left.
Set the Media property value to the following formula:
'Video Library'.Selected.'Video Link'
Step 4.10: Add the feed description HTML Text control
Enter HTML text in the search box.
Drag the HTML text control onto the screen.
Set the following properties with these values:
Property Value Font size 14 X 458 Y 651 Width 908 Height 82 Color White Select the HtmlText property from the property list on top-left.
Set the HtmlText property value to the following formula:
'Video Library'.Selected.Description
Step 4.11: Add the Published On label
Enter Label in the search box.
Drag the Label onto the screen.
Set the following properties with these values:
Property Value Font size 14 X 1153 Y 732 Width 213 Height 36 Color White Select the Text property from the property list on top-left.
Set the Text property value to the following formula:
Concatenate("Published On ",Text('Video Library'.Selected.'Published On'))
Step 4.12: Enable toggle between screens
Currently there are two separate screens, but no way to toggle between them. The ability to toggle between the screens will be important to enable the addition of more feeds.
Step 4.12.1: Add the gear icon
Select Screen2.
Select Add icon from the properties pane.
Select the Settings icon type.
Set the following properties with these values:
Property Value X 1307 Y 6 Width 48 Height 51 Color White Select the OnSelect property from the property list on top-left.
Set the OnSelect property value to the following formula:
Navigate(Screen1)
Step 4.12.2: Configure the back button
Select Screen1.
Select Add icon from the properties pane.
Select the Back icon type.
Set the following properties with these values:
Property Value X 225 Y 12 Width 32 Height 32 Select the OnSelect property from the property list on top-left.
Set the OnSelect property value to the following formula:
Navigate(Screen2)
When you select the gear icon, the app will now show the form to edit the list of feeds. Selecting the back button will return to the list of videos.
Step 5: Test the app
Before publishing the application to teams, it’s important to test core functionality.
Step 5.1: Test the Power Automate Flow
Run the Power Automate flow.
Confirm that new items have been added to the Feed Items table.
Confirm that the flow has posted new messages to the Channel you specified when configuring the application.
Step 5.2: Test the app functionality
Open the app in Power Apps Studio.
From upper-right side of the screen, select Preview.
Select the list of feed items in the gallery on the left.
When you select an item, confirm that the Title, Description, Publish Date, and the Video details are displayed.
Select the video and confirm the video plays.
Step 5.3: Test additions to the Feeds table
Add another feed to the Feeds table.
Rerun the Power Automate flow.
Repeat the above steps.
Step 6: Publish the app
Select the Publish to Teams icon in the upper right.
Select Next.
Select + next to the channel, such as Readiness to add the app to.

Select Save and close.