web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Workflow check condition on 1:N

(0) ShareShare
ReportReport
Posted on by

Hello -

I have 2 custom entities to house orders with line item details  Which are fed to CRM through an integration with another system.  We chose not to use the OOTB Order entity because we didn't need the complexities that came with it since there is no interaction with the orders in CRM - they are basically for view only purposes.

Currently, the other system is only feeding a status (Status Reason) to CRM for each line item in the order.  We would like to have an overall order status using the Status Reason field for the order.  The overall order status would be dependent on the particular status combination on the various order line item records attached to the order record.

I was hoping to use a check condition in an Order workflow to check the condition of the related order line detail records, but list of related records to choose from appears to only include the N:1 related entities and not the 1:N related line item entity.

Is there a way to allow for the check condition to work on the 1:N related entity?  Or does anyone have ideas on how else I might achieve this?

Incidentally, we are on CRM 2015 (7.1) online.

Thanks,

Jill

*This post is locked for comments

I have the same question (0)
  • David Jennaway Profile Picture
    14,065 on at

    The check condition can't work on the 1:N relationship as there could be multiple child records through that relationship. You could try writing a workflow that runs on the child entity and therefore updates data on the parent (Order) entity. However, this may depend on the sequence of updates on the child records.

    The other option is to write a custom workflow activity to query the child records

  • Aileen Gusni Profile Picture
    44,524 on at

    Hi Jill,

    Not possible using the out of the box workflow.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans