Forum Discussion

Oskar Kuus's avatar
Oskar Kuus
Iron Contributor
Sep 07, 2018

Flow on SharePoint list

Hey Is there someone who can explain how i setup flow in a way that i get todays events from a sharepoint calendar.   I want to create a post in Teams that contain today´s events from a sharepoint...
Microsoft Flow
SharePoint
teams
Matt Weston's avatar
Matt Weston
Iron Contributor

Hi Oskar, sorry it's taken me a couple of days to get back to you. Were you able to solve this?

 

Just in case, yes I hard coded the dates into the query, however you will be able to use expressions instead to pull out and format the date as required. See my screenshot as to where I've used it. The expression looks like this:

 

formatDateTime(utcNow(),'yyyy-MM-dd')
Oskar Kuus's avatar
Oskar Kuus
Iron Contributor
Sep 09, 2018

Hi

Thanks for your reply.

No so far i have not solved this.

 

I tried this setup and got the following error

{
  "status": 400,
  "message": "Kolumnen starttid finns inte. Den kan ha tagits bort av en annan användare.\r\nclientRequestId: 0c5623f7-909f-488c-bb89-ef684d79683f\r\nserviceRequestId: ab1c8d9e-4023-0000-202a-36848dfe84d1"
}

 

screenshot: http://prntscr.com/ksf2k0

The error is in swedish, but translated it says "column starttid does not exist. It can have been removed by another user....

 

But if i go to my calendar

I clearly see the column is there and it got the correct name.

screenshot: http://prntscr.com/ksf3cz

  • Alan Marshall's avatar
    Alan Marshall
    Steel Contributor
    Sep 09, 2018
    You need to use the internal column name, if it is different to startid. To find this, go to list settings and select the column, you will see in the URL at the end the column internal name.
  • Matt Weston's avatar
    Matt Weston
    Iron Contributor
    Sep 09, 2018

    Hi Oskar Kuus, just to add some additional clarity to Alan Marshall I've taken a screenshot. The biggest thing that catches people out is the difference between the SharePoint internal name and the display name. I've attached a screenshot that will show where you can check that.

    • Oskar Kuus's avatar
      Oskar Kuus
      Iron Contributor
      Sep 10, 2018

      Thank you very much. This made everything work perfectly.

       

       

    • Oskar Kuus's avatar
      Oskar Kuus
      Iron Contributor
      Sep 12, 2018
      Matt Weston
      I hope you can help me with a thing.
      You provided me with this formula to extract "todays" events from a calendar.

      EventDate ge datetime'@{formatDateTime(utcNow(),'yyyy-MM-dd')}T00:00:00' and EventDate le datetime'@{formatDateTime(utcNow(),'yyyy-MM-dd')}T23:59:59'

      How would i change this one to make it extract all events from todays date and 5 days ahead.
      So if it is monday morning. I want to extract all events from Monday, Tuesday, Wednesday, Thursday and Friday (5 days).
      • Matt Weston's avatar
        Matt Weston
        Iron Contributor
        Sep 16, 2018

        Hi Oskar Kuus sorry for not replying before now.

         

        There are a long list of expressions that you can combine, just like you would in Excel. To figure out what 5 days are from today, you can use something like this:

         

        addDays(utcNow(),5,'yyyy-MM-dd')

Resources