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:
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!
