Power Platform Community Forum Thread Details

Hi there. Need help to simplify my flow.

General idea is that someone uses a power app from where he selects an O365 calendar and a date range and then these events need to be sent via email.

HOW I DO THIS:

I get data from a power app. This data's ParseJSON_Content gives something like this:

{
"content": "[{\"CalendarName\":\"Calendar\"},{\"CalendarDateRange\":\"January-2022\"},{\"Attendees\":[],\"Body\":{\"Content\":\"\",\"ContentType\":\"HTML\"},\"BodyPreview\":\"\",\"Categories\":.......

}

In the flow I have 3 objects:
-CalendarName

-CalendarDateRange

-CalendarEvents

Then I initiate a few variables:

-JSONbody (array with value the body of the Parse JSON)

-CalendarName, CalendarDateRange, CalendarItems (object)

-CalendarFinalItems (array)

Then I get an apply to each with the Jsonbody variable and check if the item in the loop contains CalendarName then I update the related variable with the outputs of the compose and then I compose with input:

variables('CalendarName')['CalendarName']

And the condition checks for:

CalendarName

CalendarDateRange

CalendarItems

So I get my results just fine but in CalendarItems I have lots of items (its actual O365 calendar events) and I need to get specific properties (Start Datetime, End datetime and subject) per item in this object and use it inside an array or something to be sent via email.

It feels that I am doing much work and that this could be done in a better way so any feedback is much appreciated!