Create multi day bookings within resource working hours via Power Automate/logic

(0) Share

Report

Posted on by Umer Javed

180

Hi,

My Professional services client have a requirement where resources apply to work on jobs/requirement, once the application is approved by the resource manager. we need to automatically create the booking for the approved resource.

We used Power Automate to create the booking by taking start date and duration parameter from requirement, however the challenge being the booking is created as continuous booking regardless of working hours consideration for the resource.

E.g. We specified the requirement for 32 hours from Monday 26th July -30th July 20201. Now when the booking is created by Power Automate flow it is covering entire duration from 26th July to beginning of next day(27th) 8:00 AM therefore assigning these 32 hours to the resource. So how do we specify the parameter in flow such as "Front Load" or "Remaining Capacity" are considered, so the allocation of 32 hours is done within resource working hours?

In my case, the resource is working 9-5 Monday to Friday hence i was expecting the booking to be created by the logic from Monday 26th - Thursday 29th if front load selected given resource is not assigned any other job during this time.

Thanks

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Gabriel Dias Junckes 2,428 on at

Like (1)

Report
Copy link

Link copied!

Hi.

The RSO will schedule it within the resource requirement parameters.

Or you can use the WebApi to find the resource availability, you probably can call an HTTP request from Flow or use Logic Apps.

Regards,

Gabriel.

Was this reply helpful? Yes No
Ali Khan 1,380 on at

Like (0)

Report
Copy link

Link copied!

Agree with @Gabriel here. Web API is the way to go. Based on experience, logic apps (versus Power Automate) worked better for us for this sort of requirement.

Was this reply helpful? Yes No
Verified answer

Al Iggs Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

RSO will NOT work, as it is designed to schedule RRs with less than 24 hours duration; plus RSO does NOT break down a 32-hour RR into smaller pieces.

Was this reply helpful? Yes No
Umer Javed 180 on at

Like (0)

Report
Copy link

Link copied!

Thanks Gabriel and all, this seems to be a long-winded solution given I would expected the functionality to be available pretty much like Resource requirement where the allocation method parameter(e.g. Front load) takes care of creating bookings within resource working hours...

So ideally there should be configuration support here to create such bookings via Power Automate instead of WebAPI call which will introduce complexity given you got to first split the duration into number of bookings based upon work hour template and not only that you also got to ensure the booking is done within resources working ours...E..g 9-5 Monday to Thursday if resource have 8 hours week days working pattern.

I hope there will be configuration support for such feature in future release...

Was this reply helpful? Yes No