'Apply_to_each' failed

(0) Share

Report

Posted on by K-Muller101

Good day,

I am very new to Power Automate and need assistance:

Using flow where it needs to get events from an outlook calendar, for the past 7 days, recurring and running every week on a Thursday. And then data needs to flow through to SmartSheets and insert a row with the data in designated sheet, that is mapped backed to the different columns etc. Data we are mapping back from the event in outlook is : start date and end date, subject and categories. But every time I add the categories, it creates an extra ref. 1. "apply to each" loop within the "insert row" loop. and this way it create errors and does not run the flow:

" ExpressionEvaluationFailed. The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@items('Iterating_through_all_the_events_of_last_7_days')' is of type 'Object'. The result must be a valid array."