cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Advocate III
Advocate III

Add the ability to CDS Views - to filter by a parameter

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.

5 REPLIES 5
Impactful Individual
Impactful Individual

You can customize your view to filter down to specific records. The filter is found in the bottom right of the view creator. 

 

Annotation 2019-12-16 105547.png

 

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

Advocate I
Advocate I

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:

  • If you want to dynamics filter a view for a lookup field that it's possible with the addCustomFilter function

 

formContext.getControl(arg).addCustomFilter(filter, entityLogicaName)

 

  • For a subgrid on a form, then you can dynamics filter based on the related record
  • Or you can filter a subgrid on a form with SetParameter but it is an unsupported customization
  • You can have some pre-build views and toggle them as need be

Hope this helps

 

 

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Users online (9,672)