Answered

Resource counting in shifts

(0) Share

Report

Posted on by craigmk1987

Hello,

I am looking to try and build a flow that checks the "resource count" for all shifts and then tells me whether the person count exceeds or is below a required threshold. I couldn't see anyone mention or create a topic that seemed to achieve this, but is it likely to be possible?

Thanks in advance!

Craig

I have the same question (0)

All responses (4)

Answers (1)

craigmk1987 82 on at

Like (0)

Report

Re: Resource counting in shifts

Here is the shift pattern that I'm using to test

This is a copy of my flow

I'd like to try and only populate one message, and potentially create an "open shift" in shifts for someone to opt into if necessary

Was this reply helpful? Yes No
Verified answer

v-litu-msft on at

Like (0)

Report

Re: Resource counting in shifts

Hi @craigmk1987,

You could use length() function to get the number of shift met the condition, for example:

Then use the Create HTML table action to generate an HTML table that could be inserted in Teams message send them at the same time.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
craigmk1987 82 on at

Like (0)

Report

Re: Resource counting in shifts

Hi Lin,
I've added your suggested code (thank you!) and altered a couple of the fields to be more suited to what I'm after:

But it generates the following output:

How might I limit the output to only show the group that requires the resourcing?

Thank you!

Was this reply helpful? Yes No
v-litu-msft on at

Like (0)

Report

Re: Resource counting in shifts

Hi @craigmk1987,

You could use the Filter array action to filter out these Shift you require, for example:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No