Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Find a record in the g...
Finance forum
Unanswered

Find a record in the grid of the form which has dynamic tables as datasource (multi-select lookup)

(0) ShareShare
ReportReport
Posted on by 288

regarding my old question, I have been customizing D365 multi-select lookup to let users edit selection by the keyboard. 

I want to find a record in the grid of my custom lookup window. A user enters words with ";" separator then we should find the related records in the grid.  As can be seen in the below picture user types issued in the control of the form.  what I want is to find record which contains Issued.

7750.PNG

this entered word is always in the first column of the grid. Because the value of the selected record in the lookup window is always the first column of the record which is shown in the control. 

8117.PNG

The data source behind this form is Common and just store RecId, TableId and dataAreaId. I am not able to access directly to the field with user-entered value unless I traverse all datasources and their fields which are in the query. This query is the one we construct for lookup data.

So for clearing the issue, imagine that we have a form which data are created based on the dynamic datasources. (for instance, see buildDesign method in class SysLookupMultiSelectGrid). How can I search a field in the table behind the form and find the related record Id?

P.S  the query which is inputted as an argument to the lookup method can consist of multiple tables.

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.

Helpful resources

Quick Links

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Blog subscriptions now enabled!

Follow your favorite blogs

TechTalk: How Dataverse and Microsoft Fabric powers ...

Explore the latest advancements in data export and integration within ...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 284,876 Super User

#2
Ludwig Reinhard Profile Picture

Ludwig Reinhard Microsoft Employee

#3
Martin Dráb Profile Picture

Martin Dráb 225,425 Super User

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans