We use SharePoint list to submit requests to create events in Office 365 outlook calendars\/shared calendars. Create a new SP list to save ‘Start date’, ‘End Date’, ‘Calendar ID’ with appropriate column types.<\/p>\n\n\n\n
Create a new Automated Flow with trigger ‘When an item is created in SharePoint’ and Add ‘Create event (V4)’ action available under ‘Office 365 outlook’ category and configure the create event action as follows,<\/p>\n\n\n\n
- Select the Calendar (Calendars or Shared Calendars) from the Calendar Id dropdown.<\/li>
- Enter Subject, Start Time and End Time, Time Zone and Body.<\/li>
- Use below expression to enter Start Time and End time in the specified format.<\/li><\/ol>\n\n\n\n
formatDateTime(triggerOutputs()?['body\/StartDate'],'MM\/dd\/yyyy HH:mm:ss')<\/code><\/pre>\n\n\n\n4. Enter calendar body content as per the requirement. <\/p>\n\n\n\n
Add ‘Update Item’ Action to capture the unique id of the created calendar event.<\/p>\n\n\n\n
![\"\"](\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-2021-11-25-172410-1.png?resize=640%2C315&ssl=1\")
<\/figure><\/li>![\"\"](\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-2021-11-25-172505-1.png?resize=640%2C165&ssl=1\")
<\/figure><\/li>![\"\"](\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-2021-11-25-173404.png?resize=640%2C545&ssl=1\")
<\/figure><\/li><\/ul><\/a><\/a><\/a><\/div><\/div><\/div>\n\n\n\nOnce flow is ready, submit a request to SharePoint list for triggering this flow to create a calendar event. Flow gets triggered and calendar event is created whenever a new request is submitted to the SharePoint list. Unique calendar id is captured to the respective SP list item.<\/p>\n\n\n\n
Next step is to create an automated flow triggers, when an event is updated\/deleted to capture the updates occur in the calendar events into SharePoint.<\/p>\n\n\n\n
- Create a new flow and select ‘When an event is added, updated and deleted (V3)’ as trigger action.<\/li>
- Get body content in text format using ‘Html to text’ convert action.<\/li>
- Get the SharePoint list item ID using ‘Id’ property from trigger body output.<\/li><\/ul>\n\n\n\n
![\"\"](\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-2021-11-25-181435-1.png?resize=640%2C233&ssl=1\")
<\/figure><\/li>![\"\"](\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-2021-11-25-181528-1.png?resize=640%2C622&ssl=1\")
<\/figure><\/li><\/ul><\/a><\/a><\/a><\/div><\/div><\/div>\n\n\n\nWe can able to find whether the calendar event is added\/updated\/deleted using ‘Action type<\/strong>‘ from trigger body output. Here, we need to get the latest data from calendar when an event is updated.<\/p>\n\n\n\n
![\"\"](\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-2021-11-25-183028-1024x364.png?resize=640%2C228&ssl=1\")
Condition to check event is updated or not<\/figcaption><\/figure>\n\n\n\n In our scenario, we need to get the Updated Status from subject and Event Title & Participants from body content.<\/p>\n\n\n\n
Subject has the Event Status value in the Subject separated by ‘\/’ delimiter and Event Title, Participants and other details is available in body content (Ref Images under Prerequisite<\/em>). Use the below expression in compose action to get status value from subject.<\/p>\n\n\n\n
last(split(triggerOutputs()?['body\/subject'],'\/'))<\/code><\/pre>\n\n\n\nNote <\/em><\/strong>: More properties are available in the output of trigger body such as ‘Required Attendees, Optional Attendees, Start Time, End Time, Location and etc.’<\/p>\n\n\n\n
Next we can get the Event Title and Participants from body, using below expressions and our content has line break between two properties\/values (Ref Images under Prerequisite<\/em>). <\/p>\n\n\n\n
\/\/ Event Title\ntrim(split(split(body('Html_to_text'),'Event Title :')[1],'Lead Host :')[0])\n\n\/\/Lead Host\ntrim(split(split(body('Html_to_text'), 'Lead Host :')[1], 'Participants :')[0])\n\n\/\/Participants\ntrim(split(split(body('Html_to_text'), 'Participants :')[1], 'Regards.')[0])<\/code><\/pre>\n\n\n\nUsing the output of the above compose actions, we can update our required properties in SharePoint list item.<\/p>\n\n\n\n
Go to the calendar event that already created to modify the details such as Subject, Body content, Required attendees and etc. and click on the send update button. Second flow get started and updates the modified details to SP list.<\/p>\n\n\n\n
Post your queries in the comment section. Happy Building \ud83d\ude42 <\/p>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
We may need to update calendar events details such as attendees, event details and etc. after the events created and those updates need to be tracked. We use SharePoint list and Power Automate to the automate this process. Prerequisite: We use SharePoint list to submit requests to create events in Office 365 outlook calendars\/shared calendars. Create a new SP list […]<\/p>\n","protected":false},"author":5,"featured_media":1568,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","footnotes":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[8,5],"tags":[50,46,51,52,33,9,10],"class_list":["post-1547","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-automate","category-powerapps","tag-calendar-event","tag-microsoft-365","tag-office-365","tag-outlook","tag-power-platform","tag-powerapps","tag-powerautomate"],"jetpack_publicize_connections":[],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-2021-11-25-181435.png?fit=762%2C277&ssl=1?v=1637844347","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":1221,"url":"https:\/\/365stack.in\/index.php\/2021\/07\/06\/a-complete-guide-for-migration-to-power-platform-pre-development-analysis-part-2\/","url_meta":{"origin":1547,"position":0},"title":"A Complete Guide for Migration to Power Platform: Pre-Development Analysis – Part 2","author":"Hemanthkumar Rajan","date":"July 6, 2021","format":false,"excerpt":"When it comes to migrating from existing technologies, a thorough study has to be done on the legacy tool starting from how the controls are used, what are the actions frequently used, things which are available in source and not available in the destination, etc. Solutions for these scenarios must\u2026","rel":"","context":"In "Power Platform"","block_context":{"text":"Power Platform","link":"https:\/\/365stack.in\/index.php\/category\/power-platform\/"},"img":{"alt_text":"Pre Development Analysis","src":"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/07\/Requirement-Anlaysis-scaled.jpeg?fit=1200%2C829&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1678,"url":"https:\/\/365stack.in\/index.php\/2021\/11\/27\/how-to-add-microsoft-forms-responses-to-database\/","url_meta":{"origin":1547,"position":1},"title":"How to add Microsoft Forms responses to database","author":"Premkumar Perumal","date":"November 27, 2021","format":false,"excerpt":"Add Microsoft Forms responses to databases using power automate will help any person\/organization to do advanced data analytics on the responses. We can add responses to list or table using Power Automate in two different ways and create your survey using Microsoft Form as a first step. Method 1: After\u2026","rel":"","context":"In "Power Automate"","block_context":{"text":"Power Automate","link":"https:\/\/365stack.in\/index.php\/category\/power-platform\/power-automate\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-2021-11-26-214110.png?fit=682%2C325&ssl=1%3Fv%3D1637943130&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1636,"url":"https:\/\/365stack.in\/index.php\/2021\/11\/29\/how-to-add-rows-in-excel-online-using-power-automate\/","url_meta":{"origin":1547,"position":2},"title":"How to add rows in Excel online using Power Automate","author":"Hemanthkumar Rajan","date":"November 29, 2021","format":false,"excerpt":"Adding rows to an excel file or exporting the data in \".xlsx\" format, which can be sent to users or other applications as data feed can be a common scenario. In this example, we used the \"Excel online business\" connector to add rows to the excel file, Previously we already\u2026","rel":"","context":"In "Power Automate"","block_context":{"text":"Power Automate","link":"https:\/\/365stack.in\/index.php\/category\/power-platform\/power-automate\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-214.png?fit=997%2C551&ssl=1%3Fv%3D1637930822&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1310,"url":"https:\/\/365stack.in\/index.php\/2021\/07\/28\/a-complete-guide-for-migration-to-power-platform-analysis-development-part-2\/","url_meta":{"origin":1547,"position":3},"title":"A Complete Guide for Migration to Power Platform: Analysis & Development – Part 2","author":"Hemanthkumar Rajan","date":"July 28, 2021","format":false,"excerpt":"This is a continuation post on the Analysis and Development series, have a look at Part -1 of this post for a better understanding. After properly analyzing the existing system, we might be in a good position to start the development. Let's see the list of things that should be\u2026","rel":"","context":"In "Power Platform"","block_context":{"text":"Power Platform","link":"https:\/\/365stack.in\/index.php\/category\/power-platform\/"},"img":{"alt_text":"Requirement Analysis","src":"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/07\/Requirement-Analysis.png?fit=1100%2C700&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1527,"url":"https:\/\/365stack.in\/index.php\/2021\/11\/21\/how-to-create-custom-attachment-control-in-powerapps\/","url_meta":{"origin":1547,"position":4},"title":"How to create custom attachment control in PowerApps","author":"Hemanthkumar Rajan","date":"November 21, 2021","format":false,"excerpt":"Attaching a file along with the form is a common requirement, By default PowerApps does not provide any attachment control. But if the SharePoint list is added as a datasource automatically the attachment control will be generated along with the controls. But if multiple attachment control has to be shown\u2026","rel":"","context":"In "Canvas Apps"","block_context":{"text":"Canvas Apps","link":"https:\/\/365stack.in\/index.php\/category\/power-platform\/powerapps\/canvas-apps\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-143.png?fit=1200%2C467&ssl=1%3Fv%3D1637483532&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1220,"url":"https:\/\/365stack.in\/index.php\/2021\/07\/05\/a-complete-guide-for-migration-to-power-platform-pre-development-analysis-part-1\/","url_meta":{"origin":1547,"position":5},"title":"A Complete Guide for Migration to Power Platform: Pre-Development Analysis – Part 1","author":"Hemanthkumar Rajan","date":"July 5, 2021","format":false,"excerpt":"If the application is going to be created from a new requirement, we can focus only on the Power Platform by analyzing the use cases of the requirement and a feasibility study should suffice for common scenarios like approval, functions, references, CRUD operations, integrations, performance, limitations has to be taken\u2026","rel":"","context":"In "Power Platform"","block_context":{"text":"Power Platform","link":"https:\/\/365stack.in\/index.php\/category\/power-platform\/"},"img":{"alt_text":"Pre Development Analysis","src":"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/07\/Requirement-Anlaysis-scaled.jpeg?fit=1200%2C829&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/posts\/1547","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/comments?post=1547"}],"version-history":[{"count":23,"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/posts\/1547\/revisions"}],"predecessor-version":[{"id":1625,"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/posts\/1547\/revisions\/1625"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/media\/1568"}],"wp:attachment":[{"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/media?parent=1547"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/categories?post=1547"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/tags?post=1547"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}