Personalized Community is here!
Quickly customize your community to find the content you seek.
Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, Power Apps, Power Automate, and Excel are powering major transformations around the globe. | View Gallery
2020 release wave 1Discover the latest updates and new features to Dynamics 365 planned through September 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 TimelineWatch the 2020 Release Wave 1 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
I'm not fully sure if there is a solution for this requirement, but I thought it doesn't hurt to ask.
I have entity A that has a date field called "End Date." Then I have entity B that is a child of entity A. Entity B has a date field as well.
On change on the end date on entity A, i want to check if there are any child records where the date field is later than the new value of entity A. if there are records that have it later, i want to throw an error.
I tired to query the records using a solution i found kaskelasolutions. but it wouldn't work.
Let me know if anyone has a solution for this. Custom code will be fine as well.
Thank You!Leibish Ringel
Your option would be custom code or 2 workflows and an additional field in entity A.
For the latter approach:-
1) Add another date field (Last Child Date) on entity A.
2) Create a workflow for entity B (triggered on create and on a change of entity B's Date field) which compares that date with the last child date on the parent entity A and its greater than the value in the parent (or the field is blank) updates the value of Last Child Date with the value in entity B.
Hi Ben and thank you for your solution.
For now we can use this a temporary solution. Wed rather not create new field and have 2 workflows running yo accomplish this task. Do you know how we can do this in code?
Thank You in advance!
You will need a plugin then running on update (triggering when the last date field is updated) which queries the child records for the date field, iterates through them to find the date furthest in the future and then compares that furthest date to the updated last date field..
Business Applications communities