Unanswered

Show related records where address is the same on lead record

(0) Share

Report

Posted on by aadilg

Hi Friends,

I am using Dynamics 365 and have multiple lead records and addresses. There are some leads that share an address (where people stay together).

When we open a lead, we want to show the a list of all the other records that share the same address. Is this possible? how can it be done?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (0)

Report
Hello @aadil-gl,

Create a SubGrid and Select Lead Entity with Type as ALL RECORDS

Make Sure You are UnSelecting(Show Related Records) and Table as Lead and View as (Active View)

Then Write below JS

function filterSubGrid(executionContext){ var formContext = executionContext.getFormContext(); var fetchxml = "<filter type='and'>" + "<condition attribute='LINE1LOGICALNAME' operator='eq' value='" + formContext.getAttribute("LINE1VALUE").getValue()+ "' />" + "<condition attribute='LINE2LOGICALNAME' operator='eq' value='" + formContext.getAttribute("LINE2VALUE").getValue()+ "' />" + "</filter>"; var subgrid = formContext.getControl("YOURSUBGRIDNAME"); subgrid.setFilterXml(fetchxml); subgrid.refresh(); }

Please find my video for How to Write JS : https://www.youtube.com/watch?v=x8kYNCkikgs&t=14s

Call the above function onLoad of Page 🙂

That's it.

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
aadilg on at

Like (1)

Report

@rampprakash , thank you so much for this. Gonna try this out and let you know how it fares..

Thanks again!

Was this reply helpful? Yes No
AnandM 41 on at

Like (0)

Report

Hi @rampprakash ,
Can we use this undocumented method setfilterxml in our implementations?

Was this reply helpful? Yes No