Disable Recent Records from Lookup Column

You may have noticed that if you add a lookup field to one of your form fields, any recent entries of the same type will appear when you go to populate the field. In some scenarios, this feature is handy. But sometimes, we want to ensure the user searches the system for all possible matches and selects the most accurate one. With the ‘Recent Records’ showing, the user may choose a recent record without searching the system, leading to an incorrect selection. Some users also find this feature confusing. Therefore, in this blog, we wanted to share how you can disable this feature on your lookup field. Let’s use the ‘Account’ field on the Opportunity form as an example.
Power x 365 Disable Recent Records from Lookup Column - 1

Note: The steps presented are only for illustrative purposes. For enterprise applications, changes should be made using Solutions in Dataverse for ease of deployment and management.

  1. In your favourite browser, go to Power Apps Maker Portal: https://make.powerapps.com/.
  2. From the left-hand navigation pane, go to Dataverse > Tables.
  3. In the All (tables) tab, search for Opportunity. From the results, click on the Opportunity table.
Power x 365 Disable Recent Records from Lookup Column - 2
  1. Click on the Forms link to see the list of forms for the Opportunity table.
  2. Click on the Form name to open the form you want to update.
Power x 365 Disable Recent Records from Lookup Column - 3
  1. In the form editor, select the lookup field.
  2. In the right-hand pane, notice the display options for the selected field. Check the ‘Disable most recently used items’ checkbox.
  3. Click Save.
  4. Finally, click Publish.
Power x 365 Disable Recent Records from Lookup Column - 4
Now, if you go to the Opportunity form, you will no longer see the recently viewed accounts. Want to take it a step further? Enable auto-search for lookup columns.
Power x 365 Disable Recent Records from Lookup Column - 5

Discover more from Power x 365

Subscribe now to keep reading and get access to the full archive.

Continue reading