Power Platform Community Forum Thread Details

Hi,

Quite a first-time flow user... I am trying to create an automated flow to do the following:

to extract the project end date from an online excel (for Biz, saved in Teams)
check if it's newly created data, if yes, then create project ID inside the same online excel file, and add a new event written "XXX Project End Date" in Outlook Calendar
if no, grab the project ID, and update the Outlook Calendar
In both cases, send reminders to teammates 1 day before the project end date, and email reminders 1 and 4 weeks prior to the project end date

I have done the followings for step 1-3 listed above, and when wanting to save the flow I received the following error message:

Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The repetition action(s) 'Apply_to_each' referenced by 'inputs' in action 'Update_event_(V4)' are not defined in the template.'.'.

(sorry I cannot find a way to upload images here... how did you guys do that? so I am typing the flow here...)

For a selected row (Excel for biz online) - nothing wrong here, selected the right table
List rows present in a table - nothing special here too, selected the right table again
For "PROJECT END DATE"
1. Apply to each: selected "value" as the output from previous steps
2. Condition: [Project end date] [is not equal to] [null]
  1. If yes > update event (V4)
    - Calendar ID=[Project calendar]
    - ID=[Project ID]
    - Subject=[Project name] has ended
    - Start time=[project end date]
    - End time=[project end date]
    - Time zone = UTC+8
  2. If no > create event (V4)
    - Calendar ID=[Project calendar]
    - ID=[Project ID]
    - Subject=[Project name] has ended
    - Start time=[project end date]
    - End time=[project end date]
    - Time zone = UTC+8
      1. after create event, add new action: Update a row (excel for biz (online))
        Location: [Project Department]
        Document Library: [Documents]
        File: [project update.xlsx]
        Table: [Table 1]
        Key Column=[Project ID]
        Key Value=PROG_[Project name]