Category: Performance
Performance - Why is LookUp better than First/Filter?
Two popular ways to retrieve a single record are to call LookUp, or First(Filter. From a performance perspective, it's better practice to call the LookUp function to return a single record. This to post describes the reason why it's better to call LookUp, compared to First/Filter.
Recent Posts
- Controls - How to set the date picker icon size - Workaround
- Low Code No Code Microsoft Power Platform Conference 2024
- Apps - The new easier way to open .msapp files 2024
- Charts - A simple way to create better graphs and charts
- Controls - How to workaround the bug when setting Radio Button fill color dynamically
- Data - How to find the common rows from 3 or more collections
- Editable Gallery - How to set a control value dynamically when a user changes the value of another control
- Formula - How to rank times including joint times and ties
- SQL Server - Grandfathered licensing model to end on October 1, 2024
- Reading Dynamics 365 and Power Platform User Group successfully holds its Q3 2024 meetup
- Bug - How to fix problem with the advanced section of the properties pane appearing blank
- What happened at the Power Apps track at the Low Code Power Summit 2024?
- Designer - The upcoming ability to copy and paste source code from the designer will be a fantastic enhancement
- Error - Diagnosing the error "Network error when using the Patch function" when saving data with a form
- Apps - How to add predefined stock background images
- Dataverse - How to work around the error "multiple levels of many-to-one relationship expansion aren't supported"
- SQL - How to return data from Stored Procedures to Power Apps
- Reading Dynamics 365 and Power Platform User Group successfully holds its Q1 2024 meetup
Blog Author
|
Tim Leung Author, software developer, Power Platform specialist |