I am struggling with a workflow and am hoping for some help from the community. Here is the business request... The requestor would like anyone in the department to be able to create a time off request that gets routed for approval. If approved, an item is created in the official team calendar which would contain approved time off requests, team events, holidays, etc. Ideally, the official team calendar would have unique permissions so it would only be editable by a small group of people. I have tried this a couple of ways, and have run into issues.
use "create item" action to create the event in the official calendar. For the Start/End Time fields, I used list lookup to grab the corresponding values from the fields in the current item. I tried to do this with the All Day Event and Recurrence fields as well.
result: error, "The workflow could not update the item, possibly because one or more of the columns for the item require a different type of information"
Seemed like the "All Day Event" and "Recurrence" fields may have been causing the issue.
Use "Copy Item" action to create the new item in the official calendar.
result: error, "The workflow could not copy the item. Make sure the source and destination lists have the same columns and column settings.
to test this out, I used two standard calendar lists with no custom columns or changes to any settings. I also tried it with one calendar, then used Sharegate to copy the calendar. I can't figure out what column settings would be inconsistent between the two, or if there is another issue.
I found the post linked below related to recurrence, and I was thinking that this might be a limitation. If that's the case, I may want to consider another approach and just keep everything in the same calendar.
Does anyone have experience with this or some insight to lend?