You’re offline. This is a read only version of the page.
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!
Hi @Mike_Langlois ,
I hope this helps. In my example, I don't see that Get Calendars (V2) is required, not sure where you are referencing that downstream.
When I add the action 'Add a row into a table' and then select Subject in the subject field, this action automatically wraps itself in an apply to each which is what you want. I added a couple more columns to test.
Here's what I would do: attempt to copy my framework and see if this works for you.
Share
Report
9
All responses (
Answers (
