Microsoft Lists - Connecting to Outlook

MarkRichardsUK with a flow in Power Automate you can easily create an event in your Outlook calendar when a new list item is added. So we have a tasklist. It must be created first in SharePoint so the flow can find it, but after that you can use it within Lists:

Then in Power Automate  go to My Flows in the menu on the left then click New flow at the top and create a new cloud instant flow - I never use the templates as they don't tend to get updated and some have errors.

Every flow must have 1 trigger - the thing that starts it running - and then a number of events.  Our trigger is "when an item is created" and you select your site and the list. 

The first action is to get the details of that item with the "get item" action and again you select your site and the list. Click in the Id field and select ID from the dynamic content box that appears on the right:

You then a couple of Compose actions to grab the start and end date of the item. In the first Compose action (which I've renamed to ComposeStart) click in the inputs field and over in the dynamic content box click on the Expression tab and enter the following expression (don't just type it into the field, it MUST go into the box in the Expression tab:

formatDateTime(outputs('Get_item')?['body/Start'], 'yyyy-MM-ddTHH:mm:ss')

For the second Compose action (which I've renamed to ComposeEnd) add the following expression:

formatDateTime(outputs('Get_item')?['body/End'], 'yyyy-MM-ddTHH:mm:ss')

Then add the Outlook "create event (v4)" action. Select your Calendar and for the Subject field select Subject from the dynamic content box. For the Start time field, from the dynamic contents box select the Outputs from the ComposeStart section. and for the End time field select the poutputs from the ComposeEnd section of the dynamic contents box. Finally select your timezone from the dropdown.

So whenever a new item gets added to your list it will autmatically add it to your Outlook calendar:

Rob
Los Gallardos
Microsoft Power Automate Community Super User