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!
Any ideas on this one?
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
User | Count |
---|---|
77 | |
18 | |
17 | |
14 | |
11 |
User | Count |
---|---|
133 | |
33 | |
31 | |
31 | |
24 |