Canvas App: Filtering a Party List field

(1) Share

Report

Posted on by RobinSp

Hi everyone,

I want to filter for an account in the "From" field (party list) in the "Phone Calls" table.

A formular like this unfortunately does not work:

Filter('Phone Calls', from = [@ModelDrivenFormIntegration].Item.accountid)

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

SpongYe 5,715 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @RobinSp

Can you confirm that the ModelDrivenFormIntegration got any data?

You can check that by add a label and then use JSON to view the data:

JSON([@ModelDrivenFormIntegration].Item)

Because its a known issue that this object can be empty.

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
RobinSp on at

Like (1)

Report
Copy link

Link copied!

Hi @SpongYe,
yes it contains data.

Thank you for your reply 🙂

Was this reply helpful? Yes No
SpongYe 5,715 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @RobinSp

I assume that "From" is a LookUp field in your "Phone Calls" table references to a related account.

Than your filter shouwld be:

Filter( 'Phone Calls', from.accountid = [@ModelDrivenFormIntegration].Item.accountid )

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
RobinSp on at

Like (1)

Report
Copy link

Link copied!

Hi @SpongYe,

this also not working.

The problem is that the the field "form" isnt recognized.

Was this reply helpful? Yes No
WiredForSound 50 on at

Like (1)

Report
Copy link

Link copied!

Any updates to this?

Was this reply helpful? Yes No
jkic 150 on at

Like (1)

Report
Copy link

Link copied!

I'm also researching this issue - I'm trying to display the Organizer column (type=PartyList) from the Appointments table, in my canvas app. I've read that you can't display PartyList fields in a canvas app. I can see the column and its data in the table's Form, but when I try to add EditForm to canvas app the field isn't listed, nor can I find it when trying to show in Gallery.

I'm beginning to find that using these fields can be a pain, and, if you only need to link the column to a single table, easier to create a new Lookup column instead.

Was this reply helpful? Yes No