Hi there,
Hopefully this is something simple and I am just being stupid, but I am trying to create a flow that reads all calendar events in a chosen calendar, and outputs their start time, end time and location into an excel file. So far I have managed to get the flow identify the calendar list, and I can see the results of the Get Calendar View Of Events (V3) when I look at it. I can see each event in a file showing all the key things I need.
When I go to add it to a row in a table I have in excel, Automate automatically adds in a Apply to Each. When I go to change the value I want the apply to each to apply to (ID, so for each ID in the calendar view of events list) it adds another layer in? Is that normal?
The add row into table is set up and seems fine, but the process fails overall with the error:
The execution of template action 'Apply_to_each_2' failed: the result of the evaluation of 'foreach' expression '@{outputs('Get_calendar_view_of_events_(V3)')?['body/value']}@{items('Apply_to_each')?['id']}' is of type 'String'. The result must be a valid array.
Bit new to all this, so have I done something stupid or does it not work how I would expect?
Many thanks!
