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

Announcements

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

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Count of the Rows that...
Power Apps
Unanswered

Count of the Rows that match the another whole column

(0) ShareShare
ReportReport
Posted on by Haseebkhatri 2

Hi,

I've looking for the solution all over internet but failed, I have one sharepoint list that contains PhysicalBatchNo and SystemBatchNo with group ID's now i want the count that verify the values of physicalBatchNo with All the systembatchNo rows plus conditions that have same ID as well.

 

I have used 

Filter(ChildList_3, PhysicalBatchNo in SystemBatchNo) 

But it's looking only row by row not by group.

 

Haseebkhatri_0-1626327088081.pngHaseebkhatri_1-1626327112913.png

 

Categories:
Building Power Apps
I have the same question (0)
  • v-qiaqi@microsoft.com Profile Picture
    v-qiaqi@microsoft.com Microsoft Employee on at

    Hi @Haseebkhatri,

    I don't quite understand your needs.

    I noticed that you have a ‘PhysicalBatchNo’ column.

    But in the image there is a similar column called ‘SystemBatchNu...’

    vqiaqimsft_0-1626335865734.png

     

    1.Are they the same column?

    2.What's the data type of 'PhysicalBatchNo' column, 'SystemBatchNo' column and 'ChildID' column?

    3.Are the three columns in the same list? ('PhysicalBatchNo' column,'SystemBatchNo' column  and 'ChildID' column )

    4.What are your specific needs? Could you explain your needs with some images?

  • Haseebkhatri Profile Picture
    Haseebkhatri 2 on at

    @v-qiaqi-msft 

    I want total count of rows of physicalBatchNumber that doesn't matches in column SystemBatchNo

     

    That should be like this

     

    Like value 1 Check systembatchnumber.rows that their childId equal to physicalBatchNumber ChildId

     

    PhysicalValue1 should match SystemValue1 then Systemvalue2 then SystemValue3 until the childId gets unequal then it should move to physicalvalue2 and keep iterating and give me count. I hope I give better idea still you are unable to understand let me know 

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 329 Most Valuable Professional

#2
11manish Profile Picture

11manish 209 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 179

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans