Notifications
Announcements
Is there a way to filter the data source? I have created an app that pulls data from the Opportunity which has alot of records on it and I was wondering if I could filter that down to a specific brand to increase the load spead of the canvas app.
Hi @phull543 ,
In Canvas, you can use Filter function to achieve your need.
DataSource of ModelDrivenFormIntegration:
Filter([@Opportunity], Brand = "IG Elements")
Best regards,
Ive already tried that formula and it didnt work. Ill send a screenshot of the error message.
May I know where did you want to filter that data source? Is it gallery or a dropdown or others?
Specific brand, by that, do you mean you want filter data source brand column to avoid duplicate for each brand and list down in your apps?
I am filtering the data source at the ModelDrivenFormIntegration to only include opportunities from the brand IG Elements
Is it your brand column use choice data type?
If yes, you will need to include .Value to your code for the Brand
Filter(Opportunity, Brand.Value = "IG Elements")
Yes my brand column is set as choice but that still didnt work. Any ideas
Im getting the error message "name isnt valid. 'Value' isnt recognized".
Data Source only put the SP list name.
Sorry, but other than Data Source property, it also has Item property, right? Can you cut/copy and paste the same code onto the Item property?
No in the model integration section the other field is called OnDataRefresh
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 721 Most Valuable Professional
Michael E. Gernaey 320 Super User 2025 Season 2
Power Platform 1919 268
