Nov 05 2021 02:46 AM
Nov 05 2021 02:46 AM
I am playing around with Microsoft lists to see what it can provide and its looking like a really good organisation tool and communication tool to keep everyone up to speed.
I created a simple list of work to be done and a start date and end date. It would be really useful if when something is added to the list it puts something in the calendar in outlook...
But I cant find a document that says this is how to do it in simple steps. Anyone got any ideas
Nov 08 2021 03:41 AM
@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:
For the second Compose action (which I've renamed to ComposeEnd) add the following expression:
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:
Microsoft Power Automate Community Super User
Nov 09 2021 10:22 AM
Firstly many thanks for your help on this.. as a complete novice to this your help and instructions are really helpful.
If I may ask for your help one more time when you have a minute that would be great.
I have put together the list and taken the steps in power automate as you suggested (I think), however when I ran it in test mode it failed with the following:
"Unable to process template language expressions in action 'Compose' inputs at line '1' and column '27852': 'The template language function 'formatDateTime' expects its first parameter to be of type string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#formatdatetime for usage details.'."
Now I have noticed that in Lists the dates are all in US format and as you can probably guess from my user name I am in the UK. So my outlook would be UK format, date and time. I have had a look around online and in here to see if I can change my lists to be in UK format so the two match in case that's the issue but with no success.
So if you have any ideas that would be great...
Many thanks again
May 18 2022 10:25 AM
I am wondering if anyone helped solve this problem? I am having the same problem --
"Unable to process template language expressions in action 'Compose' inputs at line '1' and column '27852': 'The template language function 'formatDateTime' expects its first parameter to be of type string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#formatdatetime for usage details.'." I am not very familiar with this yet and would love some direction before I invest a lot of time trying to figure out a problem that may already be easily solved.