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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / Help with Canvas App F...
Microsoft Dynamics 365 | Integration, Dataverse...
Answered

Help with Canvas App Formula

(4) ShareShare
ReportReport
Posted on by CU28011407-0 14
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
Categories:
Power Platform integration
I have the same question (0)
  • Verified answer
    Jimmy Passeti Profile Picture
    Jimmy Passeti 849 Most Valuable Professional on at
    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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
11manish Profile Picture

11manish 174

#2
ManoVerse Profile Picture

ManoVerse 58 Super User 2026 Season 1

#3
Niki Patel Profile Picture

Niki Patel 42

Last 30 days Overall leaderboard

Featured topics

Welcome to the Microsoft Dynamics 365 forum!
Identifying an Org as CDS or Dynamics
Get batch job history log from D365 FO to Power Automate
Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans