Power Platform Community Forum Thread Details

I need help realising the following program using Power Automate.

I've never used it before

We have several folders on Microsoft Teams for each one we have 7 subfolders; we must create a program, we must use Power Automate to do so. This program will go through the subfolders determining if they contain at least one PDF file and return the data. The program will track the number of subfolders that contains at least one pdf file and then provide this information as a total number out of seven. This data will be used to create a visualization that shows the progression of each folder as a color, ranging from red (0 PDFs out of 7) to green (7 PDFs out of 7). It will also provide a visualization of the progression of each folder (based on the gradient of colors). This program will help us to quickly and accurately monitor the progress of services, as well as provide guidance on which folders need more attention and resources.

To create the program using Power Automate, you can follow these steps:

Create a flow in Power Automate that will trigger when a new file is added to a folder.
Use the "Get folder" action to retrieve the subfolders within the main folder.
Use the "List files in folder" action for each subfolder to determine if it contains at least one PDF file.
Use the "Filter array" action to only select subfolders that contain at least one PDF file.
Use a "Count" action to determine the number of subfolders that contain at least one PDF file.
Use a "Condition" action to categorize the number of subfolders with PDFs into red (0), yellow (1-3), or green (4-7) categories.
Use the "Create HTML table" action to create a table that displays the number of subfolders in each category (red, yellow, green) and the total number of subfolders.
Use the "Create file" action to create a new file with the HTML table in a designated folder.
Schedule the flow to run on a regular basis to ensure that the information is always up-to-date.