Hi,
You can try to implement this through Power Automate Flow.
In my testing, a certain resource is obtained first, then 2 work order records are listed.
Finally create a booking record for each of the two work order records, with the resource being the one obtained in the previous step.
The Booking Status field is a lookup field, so a specific Booking Status record GUID is required.
Start Time field expression: formatDateTime('2024-02-08T05:00:00Z','g')
On behalf of 2/8/2024 1:00 PM
End Time field expression: formatDateTime('2024-02-08T00:00:00Z','g')
On behalf of 2/8/2024 8:00 AM
The duration is less than or equal to the time difference between the end time and the start time.
If my answer was helpful, please click Like, and if it solved your problem, please mark it as verified to help other community members find more.
If you have further questions, please feel free to contact me .
Best Regards,
Dengliang Li