Forum Discussion

Brass Contributor

Oct 26, 2018

Solved

SharePoint Event Web Part Doesn't Work

I have several calendar lists on a team SharePoint site and wanted to display them using the Event Web Part on the Homepage. I created one Event Web and it worked fine with one of the calendars. I cr...

sharepoint

Ramy Farag
Nov 09, 2018
I found out that the Events web part requires the field "All Day Event" to have a value, either true or false to show the event (it is blank when we initially create the event). To update this field in Flow after creating the event, we need to use REST API using the "Send an HTTP request to SharePoint" action. Once you assign a value to the field, the event will show up in the Events web part. Please reference the below link (Mark Invites as Full Day Event section) for the steps to set the "All Day Event" field in Flow.

https://www.anupams.net/send-meeting-invites-sharepoint-online-calendar/

Ramy Farag

Brass Contributor

Nov 09, 2018

I found out that the Events web part requires the field "All Day Event" to have a value, either true or false to show the event (it is blank when we initially create the event). To update this field in Flow after creating the event, we need to use REST API using the "Send an HTTP request to SharePoint" action. Once you assign a value to the field, the event will show up in the Events web part. Please reference the below link (Mark Invites as Full Day Event section) for the steps to set the "All Day Event" field in Flow.

https://www.anupams.net/send-meeting-invites-sharepoint-online-calendar/

John Lathbury

Brass Contributor

Nov 12, 2018

I've been fighting with this all day and I can't seem to get it to work.

I'm sure I making a mistake but I can't seem to find where.

This is what I get each time:

{"status": 400, "message": "The expression \"web/lists/getbytitle(‘Birthdays and Anniversaries’)/items(1689)\" is not valid.\r\nclientRequestId: cebef768-c985-463c-b69f-14b8ecc36129\r\nserviceRequestId: 8ebba19e-30b9-7000-07b6-538e305b00f3",

"source": "https://SITEURL/_api/web/lists/getbytitle(%E2%80%98Birthdays%20and%20Anniversaries%E2%80%99)/items(1689)", "errors": [ "-1", "Microsoft.SharePoint.Client.InvalidClientQueryException" ]}

Ole Bergtun
Brass Contributor
Nov 13, 2018
With regards to the fAlldayEvent i actually had to create an initial condition checking the all day event or not. I couldn't use the parameter from the trigger since it constantly stated True or False with capital lettering so i created a variable that got set to fAllDayEvent: true if the trigger parameter was True and vice versa.
BTW, i'm using Logic Apps
Ramy Farag
Brass Contributor
Nov 12, 2018
1- Since your list name has spaces. In the REST API use _x0020_ to represent the spaces. So your Body JSON should be

{
"__metadata": {
"type" : "SP.Data.Birthdays_x0020_and_x0020_AnniverseriesListItem"},
"fAllDayEvent" : "False"
}
2- If you are setting the fAlldayEvent to True, you must also set the EventDate and EndDate similar to the blog I included otherwise you will get an error
- John Lathbury
  Brass Contributor
  Nov 12, 2018
  Thank you!
  I wasn't thinking and tried %20 instead of _x0020_
  It works perfect now!
  - Dean_Gross
    Silver Contributor
    Nov 30, 2018
    Spaces in SharePoint are evil, and the cause of untold amount of frustration. Try to avoid them when creating new sites, libraries, and lists.
Rob Ellis
Bronze Contributor
Nov 12, 2018
I could be wrong - but in your URI field, try deleting and re-typing the ' marks around Birthdays and Anniversaries - I think you have pasted them in from somewhere and it has taken some formatting with it.
- John Lathbury
  Brass Contributor
  Nov 12, 2018
  *Facedesk*
  I'll change that and give it a try. Thanks!