web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Program to monitor the Progress of services

(0) ShareShare
ReportReport
Posted on by

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:

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 544 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 482 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 287

Last 30 days Overall leaderboard