cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Frequent Visitor

Re: SharePoint Choice Field / Events Web Part Problem

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
Highlighted
Frequent Visitor

Re: SharePoint Choice Field / Events Web Part Problem

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?

Highlighted
Frequent Visitor

Re: SharePoint Choice Field / Events Web Part Problem

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
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Users online (7,164)