Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities - Lets Get Started!
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / filter related sharepo...
Power Apps - Microsoft Dataverse
Answered

filter related sharepoint lists

(0) ShareShare
ReportReport
Posted on by isma_ept1991 16

Hi,

 

I'm trying to filter the related childs of a sharepoint list.
How can i get the childs filtered by parent??? i got those two tables related.

 

I'm trying with CHOICES function but i dont success...

Categories:
Tables
Entities
Microsoft Dataverse
  • EricRegnier Profile Picture
    EricRegnier 8,714 Most Valuable Professional on at
    Re: filter related sharepoint lists

    @WarrenBelz perhaps can help?

  • Verified answer
    Drew Poggemann Profile Picture
    Drew Poggemann 9,278 Most Valuable Professional on at
    Re: filter related sharepoint lists

    Hi @isma_ept1991 .

     

    I know I am answering with another post (sorry) but the response I think answers your question on the count of the rows.

    https://powerusers.microsoft.com/t5/Building-Power-Apps/Count-number-of-records-number-comes-from-another-sharepoint/td-p/504904 

     

    Hope this helps (this time) 🙂


    Thanks,


    Drew

  • isma_ept1991 Profile Picture
    isma_ept1991 16 on at
    Re: filter related sharepoint lists

    Hi Drew!!

    It doesn't  help me too much.
    What I really want to do, is update "totals" fields of MASTER A , counting the related child filtered.

    Thoose sharepoint lists are related.

    How can i do that????

    Captura.PNG

    Thanks in advance for your help

  • Drew Poggemann Profile Picture
    Drew Poggemann 9,278 Most Valuable Professional on at
    Re: filter related sharepoint lists

    Hi @isma_ept1991 ,

     

    There is a detailed reply in this post from Russell Thomas that articulates the filter function and how to utilize for what you are trying to do.  If this doesn't help, please let me know.  

     

    https://powerusers.microsoft.com/t5/Building-Power-Apps/Filter-based-on-Parent-and-child-relation-in-PowerApps/td-p/252553 

     

    If this solves your issue, please mark accepted solution.

     

    Thanks much,

     

    Drew

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 - Lets Get Started!
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Apps - Microsoft Dataverse

#1
mmbr1606 Profile Picture

mmbr1606 22 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 19

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 15 Super User 2025 Season 1

Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans