Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Answered

Help with Canvas App Formula

(3) ShareShare
ReportReport
Posted on by 10
I'm new to Power Apps, just playing around with Canvas Apps to get an idea of what can be done. Can any body help me with the formula I need, on the screenshot below the left hand gallery is connected to D365 Accounts and the right hand gallery links to D365 Contacts. Ideally I want to be able to select an account record from the left gallery and to the right I want the gallery to display only those contacts who are linked to the specific account I have selected. I have tried a few different formulas, however I keep getting errors.
 
 
Thanks
  • Verified answer
    Jimmy Passeti | MVP Profile Picture
    Jimmy Passeti | MVP 253 Super User 2025 Season 1 on at
    Help with Canvas App Formula
    Hello,
     
    What you need to do is use a filter in the gallery on the right side.
    It would look something like this:
     
    • On the left gallery (Account) on the "OnSelect" property should be "Select(Parent)".
    • On the right side gallery (Account), the "Items" property should be like this:
    Filter(Contacts;Gallery_Accounts.Selected = 'Account')
     
    Contacts = Contact table name
    Gallery_Accounts = Name of your left side gallery (Accounts)
    Account = The field on the Contact table that has the Account value
     
    Regards,
    Jimmy Passeti | Microsoft MVP
    ✅ Please mark as Verified if this answered your question!

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

Announcing Our 2025 Season 1 Super Users!

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

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,160 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans