If you have a file or a table on SharePoint and you want to book a date automatically whenever there is a new entry, you can use Power Automate to create a flow that triggers on item creation and uses the Book a meeting action to schedule a meeting with the relevant people.
Here's a step by step you can follow:
1. In Power Automate, click on Create and select Automated cloud flow.
2. Give your flow a name and choose SharePoint as the trigger. Select When an item is created as the trigger event and click on Create.
3. In the trigger settings, specify the Site Address and List Name of your SharePoint table.
4. Add a new action "Create item" from the SharePoint connector. Specify the site address and list name of your calendar.
5. In the fields section, map the values from the trigger output to the corresponding fields in the calendar item. For example, you can use the Title, Start Time, End Time, Location, and Description fields from the trigger output to fill in the same fields in the calendar item. You can also use expressions or variables to customize the values as needed.
5. In the action settings, fill in the required fields such as Subject, Required attendees, Start time and End time. You can use dynamic content from the trigger to populate these fields based on the item that was created. For example, you can use the Title or Name of the item as the subject, and the Created by email as one of the attendees.
7. Save your flow and test it by creating a new item in your SharePoint file or table. You should see a meeting booked in your SharePoint calendar with the details from the item.
If you get stuck, ping me and I'll provide screenshots 🙂
