Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id : JqN0cThd2jeXBPwSFVO1xz
Power Platform Community / Forums / Power Automate - Building Flows / Multiple Lists - Statu...
Power Automate - Building Flows
Suggested answer

Multiple Lists - Status Report

Like (1) ShareShare
ReportReport
Posted on 14 Mar 2025 19:16:30 by CU14031914-0
We have been using Lists in Sharepoint for Corrective Action Plans for multiple locations (~100)
 
I am trying to figure out a way to get a report of all items that are "In Progress" under a column dropdown we named "Status".
 
Is this a possibility?
Categories:
Business Process Flows
  • Suggested answer
    Michael E. Gernaey Profile Picture
    Michael E. Gernaey 36,029 Super User 2025 Season 1 on 14 Mar 2025 at 20:25:55
    Multiple Lists - Status Report
     
    When you say a report can you provide more context to that?
     
    When you ask if it's possible, possible in what way? IN an app, in power bi, in power automate?
     
    You can leverage Power automate to use a Get Items, and then filter on rows that only have a status of In Progress
     
    You can then push them to Excel, or Power BI, or just Connect Power to the List and report it that way.
     
    But yes, you can do it many ways, but need you to please be more specific in how.

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Thomas Rice – Community Spotlight

We are honored to recognize Thomas Rice as our March 2025 Community…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,508 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,436 Most Valuable Professional

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans
Liquid error: parsing "/forums/thread/?category=cb8569a5-2045-4a76-8047-758de2eb38d3&page=1&sortorder=mspwrplt_cmty_latestactivitydate&status=1KlAkGoch'))%20OR%20544=(SELECT%20544%20FROM%20PG_SLEEP(15))--" - Too many )'s.