Answered

Mapping Calendar Event Category(ies) Using a Variable

(0) Share

Report

Posted on by MarcusD1

271

I have a flow I built that takes input from a MS Form, and uses two variables to save an element of the submission to a specific folder in a document library. I.e. if the respondent said they live in a certain state, I have an Object variable that maps 'Alabama':'Southern Region', and so on...

and the subsequent variable takes the specified state input from the form and assigns the correct region:

variables('varRegions')?[outputs('Get_response_details')?['body/rf0c4529364ef42d18522441d560f9fad']]

And it works great. But now I'm trying to do something similar taking values from a Calendar Event, and using the first variable to map "Categories" (aka "tags") assigned to the event, and mapping those to a broader category group:

and then use the subsequent variable to grab the actual category for a specific event for use later in the flow (specifically, adding that value to a column in a SharePoint list):

variables('varSubCategories')?[outputs('Get_calendar_view_of_events_(V3)')?['body/categories']]

But when I run the flow, I receive this error message:

Unable to process template language expressions in action 'Initialize_variable_Categories' inputs at line '0' and column '0': 'The template language expression 'variables('varSubCategories')?[outputs('Get_calendar_view_of_events_(V3)')?['body/categories']]' cannot be evaluated because property '' cannot be selected.

What am I doing wrong?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-dezhili-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @MarcusD1 ,

First, the output of the Get calendar view of events (V3) action is an array named "Value", and categories are nested in "Value". So you can't call it directly with outputs().
Second, the categories under "Value" may be arrays or strings. It will be an array when the category of your calendar event supports multiple selection.
Finally, if you want to get the category of the calendar event, you need to use Apply to each action to get all the events in this time interval, and then if your calendar event has only one category, you can directly get it with:
item()?['categories' ][0]

Office 365 Outlook - Connectors | Microsoft Learn

Best Regards,
Dezhi

Was this reply helpful? Yes No
MarcusD1 271 on at

Like (0)

Report
Copy link

Link copied!

This was helpful and I was able to get my flow working the way I wanted. Thanks.

Was this reply helpful? Yes No