How to Count Rows in Power Automate | SharePoint Get Items + Dataverse List Rows
💡 Help the Channel Grow!
YouTube revenue is modest! If these tutorials save you time or help you build better solutions, optional tips directly support continued content creation. Supporters may receive priority consideration for content requests or responses to questions. 👉 Support here: https://streamlabs.com/officesolution...
👉Schedule a 60-minute consultation: https://calendly.com/travis-officesol...
🚀 Need to count rows in Power Automate? In this tutorial, I’ll show you the simple pattern that works for both SharePoint lists and Dataverse tables.
In this video, you’ll learn how to count rows returned from a SharePoint Get items action and a Dataverse List rows action using the Power Automate length() expression.
This is one of those small Power Automate skills that can make your flows much more useful. Once you know how to count rows, you can check whether records exist, stop unnecessary flow runs, prevent empty emails, make decisions with conditions, and build smarter automations.
👉 In this tutorial, we’ll cover:
✅ Why row counts are useful in Power Automate
✅ How to count rows from a SharePoint list using Get items
✅ How to count rows from Dataverse using List rows
✅ How to use the count inside a Condition
✅ Why the same basic pattern works across different data sources
✅ What to watch out for with large SharePoint lists and Dataverse tables
✅ Common mistakes when counting rows in Power Automate
The key expression we’ll use is:
length(outputs('Get_items')?['body/value'])
And for Dataverse:
length(outputs('List_rows')?['body/value'])
By the end of the video, you’ll understand the basic row-counting pattern and how to reuse it in your own SharePoint, Dataverse, and Microsoft 365 automation workflows.
💡 Help the Channel Grow!
YouTube revenue is modest! If these tutorials save you time or help you build better solutions, optional tips directly support continued content creation. Supporters may receive priority consideration for content requests or responses to questions. 👉 Support here: https://streamlabs.com/officesolution...
👉Schedule a 60-minute consultation: https://calendly.com/travis-officesol...
#PowerAutomate #SharePoint #Dataverse #Microsoft365 #PowerPlatform #OfficeSolutionsPro #Automation #MicrosoftFlow