Trigger Field Change Based on Another Entity Field Value in Model-Driven Apps
I am building a fairly basic Case Management System using Model-Driven Apps in PowerApps. I am trying to create a basic way of tracking specific status criteria of each Case. I have found Workflow helpful but it is quite set in stone and not all real world Cases follow this quite rigid linear path and may jump stages, repeat stages etc. I have also tried using Business Rules but this appears to be limited to within an entity.
Anyway, I basically want to setup something like a 'Status' option set field, much like how the OOTB Status field displays whether a record is Active or Inactive. I want to set this up so that (for example) this custom 'Status' field would change based on a field change elsewhere...this is possible through Business Rules however I can't find a way to make this possible if I want to set the custom 'Status' field to change based on another entity's field value.
To give an example, I would like each Case to have (at least) 3 status options:
1. Referral received
2. Referral validated
3. First Contact
My solution was to create 3 separate fields for each of these status options which will then be marked as Yes or No depending on whether they have taken place. The first 2 status options were possible to set through Business Rules however, I would like the 3rd option status (First Contact) to be based upon a field change to a different entity (which would be related to the Case record).
My questions are: Is there a way to set this up in the way that I have started to do this? Or is there a much better way to do this? I want this process to all be automated - would Flow be able to do this?
Thanks for getting this far and any thoughts would be really appreciated 🙂
I have exactly the same requirement. I have a new hire entity and when the user selects a job title I want to bring over the job grade from the job title entity. These entities are linked via a lookup field. This gets me the job title but how can I bring over other field values?