Answered

Create Calendar Event from SharePoint List - Not able to select SP Date Fields

(0) Share

Report

Posted on by adminrookie

I am trying to build what I thought would be a basic flow. I want to create a calendar event based off the "Date" columns (date picker) in a SharePoint List. I've read similar examples on this and other sites, but am apparently doing something wrong because I can not select the date fields for my Start and End times. My Flow looks like this:

As you can see, for "Subject", I have the option to select the "Start Date" and "End Date" fields. However, for the "Start time" and "End time", those options are not there. In the examples I've found (https://powerusers.microsoft.com/t5/Building-Flows/Create-calendar-event-based-on-SharePoint-List/td-p/300431) the Date fields seems to be there, as that user was able to enter them into their Flow. What am I doing wrong that is preventing me from selecting the Date fields?

I have the same question (0)

All responses (5)

Answers (1)

adminrookie 15 on at

Like (0)

Report

Re: Create Calendar Event from SharePoint List - Not able to select SP Date Fields

I wanted to add that after testing with the "Create Event in Google Calendar" action, everything work fine. The Google Calendar action allows me to select the date fields from the SharePoint List and when I create/update an item, the event is created in Google Calendar. I just don't know why this virtually exactly the same action does not allow me to select the Date fields for the Outlook version.

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

Re: Create Calendar Event from SharePoint List - Not able to select SP Date Fields

@adminrookie

In SharePoint List date column allow selection of time through edit column settings. Once you do that use below dynamic content as shown in image-

Time zone- it is your local time zone which will create events in local time.

Let me know if you face any problem.

Thanks
Hardesh

Was this reply helpful? Yes No
adminrookie 15 on at

Like (0)

Report

Re: Create Calendar Event from SharePoint List - Not able to select SP Date Fields

Hardesh,

I did try that, and it is having no affect. I've tried different browsers (new Edge and Chrome) also.

As you can see below, I can select the Date fields fine for the Google Calendar action.

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

Re: Create Calendar Event from SharePoint List - Not able to select SP Date Fields

@adminrookie

Can you please share your Trigger in expanded mode.

Thanks
Hardesh

Was this reply helpful? Yes No
Verified answer

adminrookie 15 on at

Like (2)

Report

Re: Create Calendar Event from SharePoint List - Not able to select SP Date Fields

Hardesh,

Thanks for the help but I figured it out, and it was a really stupid reason. For whatever reason, all my SharePoint List Date fields do not populate into the Dynamic Content window for the "Start time" and "End time" inputs. I have to manually search for them to get them to show up. That does not explain why they show up for the other inputs, but it looks like manually searching for the field works.

Was this reply helpful? Yes No