Get the number of groups for requested Items

[Rakshanda Kunte]

Hi All,

Req: Need to create a new catalog item where input will be 'Item' and we get the output that 'how many groups have raised requests using 'ABC'(this is input of the catalog item) catalog item. I also need to create a Flow designer.

Variables:

1. Item

Output should be:

1. Showcase Number of Groups/teams raised request using ABC catalog item.

2. Names of Groups/Teams raised request using ABC Catalog item.

3. Showcase Number of Groups/teams who have not raised any request using ABC catalog item.

4. Names of Groups/Teams who have not raised request using ABC Catalog item.

I can do the scripting in flow designer.

Can anyone help with scripting?

Thank you..

[Rakshanda Kunte]

@Ankur Bawiskar 

To get department data, I am dot walking as below.

RITM-> Requested For -> department-> (And here group by level4)

Here, we can get required departments by grouping only.

For this, I am looking for script.

Is this possible?

Output will look as below:

Department 1: 4RITM

Department 2: 2 RITM

Department 3: 10RITM

Department 4: 11 RITM

[Ankur Bawiskar]

@Rakshanda Kunte 

yes it's possible.

check this link I have shared solution for something similar but it was for incident table

you can enhance it for your case

How to trigger multiple notifications for multiple users ? 

If my response helped please mark it correct and close the thread so that it benefits future readers.