Forum Discussion
Microsoft Lists - Connecting to Outlook
Hi RobElliott
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
Hi,
Hi,
I think you could use https://answers.microsoft.com/en-us/msoffice/forum/all/how-to-change-the-date-format-for-the-new/03206b6c-9ec0-4460-b38a-ccd3fdee30e7#:~:text=Replied%20on%20September%207%2C%202020-,Hi%20Paul.A.Miller%2C,%3DTEXT(Created%2C%22DD/MM/YYYY%22),-I%20appreciate%20your%20patience%20and to create UK format date columns and then replace the original ones in your flow with the ones that have the right date format for you.
Hope that helps.