Help with Canvas App Formula

(4) Share

Report

Posted on by CU28011407-0

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)

All responses (1)

Answers (1)

Verified answer

Jimmy Passeti 669 Most Valuable Professional on at

Like (2)

Report
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!

Was this reply helpful? Yes No