Notifications
Announcements
No record found.
i have a table Comments table with two columns:
Code
comments
S01
test1
S03
test2
S04
test3
S06
test4
other one is Main table where user will update the activity code and comments should auto populate from the Comments table
how can i achieve this?
Hi,You can use Power Automate, Javascript and Plugin for the same.In Power Automate, you can set a trigger point on Create/Update of Code and based on code value it will go to comment table and will fetch record. Once record found then you can set it on Main Table comment field.In Javascript, you write onChange event whenever user changes the code value then you can fetch value and set it on comment table.In Plugin, logic will be same as power automate.Other way is, you can use dynamic CRM relationship for example you can have N:1 Relationship between Main Table and Comment table. Once you create relationship then you can use Quick View Form to show value from related table as described in below link:https://www.marksgroup.net/blog/dynamics-365-quick-view-forms/
If you need the data immediately/synchronized once user changes the code field on main form then go ahead with the JS(on change event of code field).... If u want to run this logic in Background then you can use power automate.
Else if you just want to show comment field, then the best way will be Quick view form.. Where you will not have to do any customizations.....
www.marksgroup.net/.../
Thank you,
Amit Katariya
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Tom_Gioielli 170 Super User 2025 Season 2
#ManoVerse 70
Jimmy Passeti 50 Most Valuable Professional
