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
Oskar Kuus's avatar
Oskar Kuus
Iron Contributor

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

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.

  • 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')
  • 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).
  • Oskar Kuus's avatar
    Oskar Kuus
    Iron Contributor
    Sep 10, 2018

    Thank you very much. This made everything work perfectly.

     

     

Resources