cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ThomasS
Frequent Visitor

SharePoint Choice Field / Events Web Part Problem

So I'm having a lot of trouble with selecting drop-down options from a choice field in my SharePoint list using Flow. The full workflow is: a user submits a form for time off, the form data is logged in a SharePoint list and an approval workflow begins. When/if the request results in an "approved" status, another flow creates an event on the department calendar.

 

Here is a screenshot of the "Create Item" step for the calendar:

CreateItem.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

I originally used the "Department" value from the list that the request is recorded in as my custom value for the "Category Value" as the category options all match our sales departments. The flow runs and works correctly in that approved requests will pick the correct category from the list of options if their department matches. The problem I'm having is while using an Events web part on a modern site page in SharePoint. Originally, none of my events were being seen by the web part, but I modified the managed properties for the ows_q_CHCS_Category crawled property in our search schema. That allowed my manual test events to show up when filtered to "All Events". Unfortunately any events created by my Flow do not show up in the web part. I have to edit the event after it is created and select the category choice it already has selected and save the event again for it to appear in the web part. 

 

I will admit, I didn't pick the "Category" column from the out-of-box options; I created a new column and made it a choice. Other than that, I can't see why the text entered by Flow is any different from the text I choose manually from the drop-down list. I even thought maybe Flow needed a list value like 1, 2, 3 and so on, but it actually says "Category Value" which would be the text. I'm at the point where I'm afraid my troubleshooting may cause more problems than it will fix so I'm hoping maybe someone can help me out here. I really would appreciate any help.

 

Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
ThomasS
Frequent Visitor

I did some more searching and eventually found the answer. I'm going to post this for anyone else's resource as it resolved my issue: https://techcommunity.microsoft.com/t5/Office-365/SharePoint-Event-Web-Part-Doesn-t-Work/td-p/278530

 

It looks like events created by Flow do not place a value in the "All Day Event" column, and that attribute is required for the Events web part. The OP in the link above went through all of the same steps I did and eventually someone mentioned that you can use the "Send HTTP Request to SharePoint" option in Flow to update that field manually. Works like a charm!

View solution in original post

2 REPLIES 2
ThomasS
Frequent Visitor

I have an update: I checked my calendar/event list's "All Events" view, and there was a new column that didn't appear in my list settings. It was "All Day Event". Unfortunately that is a feature I neither want to or am able to delete as its tied to the Event content type. The events crated by my Flow don't have any value in that field, but I've noticed when I manually edit these events the column defaults to "No" which in-turn shows the event in the Events web part. I tried to make the column default to "No" but that configuration resets every time I refresh the page. 

 

Does anyone know how to set the "All Day Event" attribute to a default value, have it set by a Flow?

ThomasS
Frequent Visitor

I did some more searching and eventually found the answer. I'm going to post this for anyone else's resource as it resolved my issue: https://techcommunity.microsoft.com/t5/Office-365/SharePoint-Event-Web-Part-Doesn-t-Work/td-p/278530

 

It looks like events created by Flow do not place a value in the "All Day Event" column, and that attribute is required for the Events web part. The OP in the link above went through all of the same steps I did and eventually someone mentioned that you can use the "Send HTTP Request to SharePoint" option in Flow to update that field manually. Works like a charm!

View solution in original post

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,708)