Count all meeting slots

[Radoslavov]

Hi guys,

I'm using Power Automate to check my calendar for available slots of let's say 30 minutes.

The flow works fine, the output shows all available 30 min slots in my calendar, but what I want it somehow to summarize them all, so i can pass the result to Power Virtual Agent.

For example: "you have 5 available slots of 30 minutes in your calendar"

this is the output

[

  {

    "confidence": 100,

    "organizerAvailability": "free",

    "attendeeAvailability": [],

    "locations": [],

    "meetingTimeSlot": {

      "start": {

        "dateTime": "2020-12-18T00:00:00.0000000",

        "timeZone": "UTC"

      },

      "end": {

        "dateTime": "2020-12-18T00:30:00.0000000",

        "timeZone": "UTC"

      }

    }

  },

  {

    "confidence": 100,

    "organizerAvailability": "free",

    "attendeeAvailability": [],

    "locations": [],

    "meetingTimeSlot": {

      "start": {

        "dateTime": "2020-12-18T16:00:00.0000000",

        "timeZone": "UTC"

      },

      "end": {

        "dateTime": "2020-12-18T16:30:00.0000000",

        "timeZone": "UTC"

      }

    }

  },

  {

    "confidence": 100,

    "organizerAvailability": "free",

    "attendeeAvailability": [],

    "locations": [],

    "meetingTimeSlot": {

      "start": {

        "dateTime": "2020-12-18T16:30:00.0000000",

        "timeZone": "UTC"

      },

      "end": {

        "dateTime": "2020-12-18T17:00:00.0000000",

        "timeZone": "UTC"

      }

    }

  },

  {

    "confidence": 100,

    "organizerAvailability": "free",

    "attendeeAvailability": [],

    "locations": [],

    "meetingTimeSlot": {

      "start": {

        "dateTime": "2020-12-18T17:00:00.0000000",

        "timeZone": "UTC"

      },

      "end": {

        "dateTime": "2020-12-18T17:30:00.0000000",

        "timeZone": "UTC"

      }

    }

  },

  {

    "confidence": 100,

    "organizerAvailability": "free",

    "attendeeAvailability": [],

    "locations": [],

    "meetingTimeSlot": {

      "start": {

        "dateTime": "2020-12-18T17:30:00.0000000",

        "timeZone": "UTC"

      },

      "end": {

        "dateTime": "2020-12-18T18:00:00.0000000",

        "timeZone": "UTC"

      }

    }

  },

  {

    "confidence": 100,

    "organizerAvailability": "free",

    "attendeeAvailability": [],

    "locations": [],

    "meetingTimeSlot": {

      "start": {

        "dateTime": "2020-12-18T18:00:00.0000000",

        "timeZone": "UTC"

      },

      "end": {

        "dateTime": "2020-12-18T18:30:00.0000000",

        "timeZone": "UTC"

      }

    }

  },

  {

    "confidence": 100,

    "organizerAvailability": "free",

    "attendeeAvailability": [],

    "locations": [],

    "meetingTimeSlot": {

      "start": {

        "dateTime": "2020-12-18T18:30:00.0000000",

        "timeZone": "UTC"

      },

      "end": {

        "dateTime": "2020-12-18T19:00:00.0000000",

        "timeZone": "UTC"

      }

    }

  },

  {

    "confidence": 100,

    "organizerAvailability": "free",

    "attendeeAvailability": [],

    "locations": [],

    "meetingTimeSlot": {

      "start": {

        "dateTime": "2020-12-18T19:30:00.0000000",

        "timeZone": "UTC"

      },

      "end": {

        "dateTime": "2020-12-18T20:00:00.0000000",

        "timeZone": "UTC"

      }

    }

  },

  {

    "confidence": 100,

    "organizerAvailability": "free",

    "attendeeAvailability": [],

    "locations": [],

    "meetingTimeSlot": {

      "start": {

        "dateTime": "2020-12-18T22:00:00.0000000",

        "timeZone": "UTC"

      },

      "end": {

        "dateTime": "2020-12-18T22:30:00.0000000",

        "timeZone": "UTC"

      }

    }

  },

  {

    "confidence": 100,

    "organizerAvailability": "free",

    "attendeeAvailability": [],

    "locations": [],

    "meetingTimeSlot": {

      "start": {

        "dateTime": "2020-12-18T22:30:00.0000000",

        "timeZone": "UTC"

      },

      "end": {

        "dateTime": "2020-12-18T23:00:00.0000000",

        "timeZone": "UTC"

      }

    }

  },

  {

    "confidence": 100,

    "organizerAvailability": "free",

    "attendeeAvailability": [],

    "locations": [],

    "meetingTimeSlot": {

      "start": {

        "dateTime": "2020-12-18T23:00:00.0000000",

        "timeZone": "UTC"

      },

      "end": {

        "dateTime": "2020-12-18T23:30:00.0000000",

        "timeZone": "UTC"

      }

    }

  }

]

Any suggestions what ste[/steps to add to summarize the results from this step?

Regards

[VictorIvanidze]

Hi @Radoslavov, it seems you have just use "for each"  cycle - what's the problem?

[Radoslavov]

"what I want it somehow to summarize them all, so I can pass the result to Power Virtual Agent.

For example: "you have 5 available slots of 30 minutes in your calendar"

Count all as one total number

[Radoslavov · Accepted solution]

I found the solution to count all items in an array by using the following formula fro compose step

length(variables('SlotNumber'))

this way I get a value of all items in an array which in my cases there are available slots in my calendar

[VictorIvanidze]

Could you please explain where and how did you set the variable 'SlotNumber'?

[Radoslavov]

Sure, I've created an array (called SlotNumber) that stored all available outputs from my calendar

Then in the count all available slots step I'm using the output from the array.

[VictorIvanidze]

I  believe there exists an alternative:

length(outputs('Find_meeting_times_(V2)')?['body/meetingTimeSuggestions'])