I am new to SharePoint and Flow, this is my first project using the two, so I really have no idea what to do.

I created a SharePoint site of 198 calendars, using SharePoint online, and am trying to create a central list where events can be entered and a flow will create the events in the proper calendar.

I have a list called Event List where users will enter the title, location, start and end time of an event. I would then like the flow to link the location to the title of the calendar (location:00 calendar:Store 00), and create the event using the title, start and end time.

Event List with Test Event Test Store 500 Calendar

Below is a non-working example of what I am trying to do. I don't want to set the list name but want the flow to find the calendar based on the location in the event list.

Non-working flow

  • Currently I have created a single flow for each calendar. It works for now until a better solution can be figured out. – Erin.B Jan 10 '19 at 16:31

A simple demo for your reference, you could get the item data from Dynamic Content.

enter image description here

|improve this answer|||||
  • Hi, I have updated my question to better explain what I am trying to achieve. If your answer still applies would you please help me understand? Thank you for taking the time to answer. – Erin.B Nov 26 '18 at 15:46
  • 1
    Not so clear about your description, when I did test, Flow won't list calendar list, it works fine by 'Enter custom value'. – Lee_MSFT Nov 27 '18 at 7:58

I don't think that Flow currently supports selecting either the list or the SharePoint site url. Workarounds include creating an azure function that adds the item to the calendars, and calling that function from a flow, or perhaps calling the SharePoint rest api from flow.

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.