Hello All,
I have a Dataverse table where I store information about people being scheduled for certain tasks. To keep it simple let's assume that every record consists of three fields:
1. Barcode
2. Start Date
3.End date
Is there any way prevent a user from submitting a form if they would like to submit a record with overlapping dates? For example an existing record would be:
{Barcode: 123, "Start Date":"2023-03-01T00:00:00Z", "End Date":"2023-03-31T00:00:00Z"}
and someone would like to insert the following:
{Barcode: 123, "Start Date":"2023-03-02T00:00:00Z", "End Date":"2023-03-15T00:00:00Z"}
There is clearly a time conflict between these two and therefore I would like to prevent someone from adding it and if possible notifying him/her about it.
I would like to mention that I was able to achieve it in a canvas app using a "Display Mode" property of a button which is responsible for canvas app form submitting.
Thank you all in advance!
Canvas App Form
Model Driven Form
