Announcements
Being able to use Views defined on the CDS entities is great for Power Apps, however, you still have to fetch all your rows and use filtering within the app to limit the data presented to the user. I would like to be able to pass a parameter to the CDS view in order to limit the rows fetched from the server.
You can customize your view to filter down to specific records. The filter is found in the bottom right of the view creator.
---Please hit the "Accept as Solution" button if my post answered your question! If my post was helpful please consider giving it a "Thumbs Up."
Yes - the filtering is available - but it is a static filter - I am looking for a dynamic filter - where I can pass a variable from a Pwer App to the View.
Somebody, I need to same. I need to have the possibility to add a variable name. So that I can pass a value from the powerapps selection to the view. Thanks
This feature would be extremely helpful
Hi @barlowse,
It is not possible out-of-the-box to have a dynamics filter in the entity list page (clicking the entity from the sitemap). For what exact scenario are you trying to have a dynamics filter? There are probably a few workarounds, for instance:
formContext.getControl(arg).addCustomFilter(filter, entityLogicaName)
Hope this helps
Thanks for the reply Eric. I am building canvas apps on custom cds tables.I guess to put it simply, I am looking for something like a stored procedure in SQL that I can pass a variable piece of data to and have the server do all of the filtering. Using custom views on the cds table will only get me so far, because it has to be a known value. The best workaround I have been able to do is, to use a static field that I populate with a value for example "Record 1", and then build my view using this field in the filter. However if this field has hundreds of different values - I have to build that many custom views. Which is not ideal. Power Automate could preform the feat for me, but I have not had positive experiences using a flow in a canvas app and the time it takes to return results has not been less than acceptable.
Hi @barlowse, thanks for clarifying. Since you're using canvas apps, options are:
Think Filter is the only method provided.
Filter('Contacts', _accountid_value = GUID("record_guid"))
Filtering is what used with the views, so its working. Also I added an Idea here https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Make-CDS-Views-accept-parameters/idi-p/525667
for consideration.
@barlowse I have a similar need and also voted for your proposal. I have a set of category fields for my records in dataverse. The use of the OOB filter would work but involves too many clicks for my end users (and some of them have difficulties defining queries for related data). We try out a custom page where uses can select desired categories and use power automate flow to compose a fetchXML query, which retrieves the desired records.
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 505
WarrenBelz 502 Most Valuable Professional
Haque 324
