Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Concatenation of Text fields from all child records OnUpdate of child record

(0) ShareShare
ReportReport
Posted on by 277

Hi Experts, I'm working on a requirement to get a text field value from all child records when text field on one of child record is updated and update it on the parent, can you point me in a correct direction what to do within or after foreach loop? or any related references? thank you. 

*This post is locked for comments

  • Turbo Forms Profile Picture
    Turbo Forms 277 on at
    RE: Concatenation of Text fields from all child records OnUpdate of child record

    Hi Sir, my apologies to not mention the exact point of issue. I got to a point retrieving multiple child records, I'm stuck at the point to hold the values for each child record. I have checked multiple example regarding StringBuilder but all of them fails to explain how to store each string during for each loop. Thank you

  • Turbo Forms Profile Picture
    Turbo Forms 277 on at
    RE: Concatenation of Text fields from all child records OnUpdate of child record

    Hi Adrian, I got to a point retrieving multiple child records, I'm stuck at the point to hold the values for each child record. Can I get more info about storing the result in list? Thank you

  • Suggested answer
    Arun Vinoth Profile Picture
    Arun Vinoth 11,615 on at
    RE: Concatenation of Text fields from all child records OnUpdate of child record

    This is too broad question, that too not started with a bit of coding. Check this of thread: community.dynamics.com/.../163275

    1. Trigger plugin on child record field update (along with parent lookup field in image)

    2. Use Retrieve multiple service call to fetch all the other child records using the parent lookup from image in filter

    3. Iterate through all the child records & store the text in a variable using StringBuilder class append method

    4. Finally update the parent record

  • Suggested answer
    Adrian Begovich Profile Picture
    Adrian Begovich 1,019 Super User 2025 Season 1 on at
    RE: Concatenation of Text fields from all child records OnUpdate of child record

    Hi Turbo Forms,

    You can achieve this with a Plugin that runs when the text field on a child record is updated. In your Plugin, you will need to retrieve the text field from each of the child records using a FetchXML, QueryExpression or LINQ query and store the result in a list. You will then need to loop through the list and update the parent record.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,329 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans