I have a business requirement to perform real-time (synchronous) data checking which is more complicated than a Business Rule will allow:
- If {lookup field value} in {related record} is equal to {lookup field value} in {other related record}, prevent save and alert the user.
- On save, update {lookup field value} with {lookup field value} from {related record}
- On save, check if {date in related record} is later than {date in record related to another related record} and if so, update {third related record}
We also use real-time Workflows to name many records on record creation.
Using asynchronous workflows to do this was upsetting many users who thought their changes had not taken place, so performance is not a consideration.
Since Workflows cannot be created in the PowerApps environment, and MS Flow cannot run synchronously, what is the recommended alternative? Is it form-level Javascript? If that is the case, how do we perform data checks on bulk-edited records?