cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Clarizion
Regular Visitor

Trying to get Calendar Event Description

I am setting up a reoccurring Flow that is used to notify a distribution group of specific events within the Calendar list.

I have created the flow needed to find the event and it works very well.  Not the most efficient but works.

 

I use a Get Items to collect the events from the list.

Then in the Apply to each I filter the items to take actions on. (I haven't been able to get an oData filter to work even using the le and ge as I have seen in other posts).

 

I then try to collect the Description and set it to a variable using the expression 'item()?['Description']' but it always come up empty.

ConditionAndSetVariable.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

The problem is that I am unable to determine how to get the Event Description

 

Any suggestions or recommendations would be appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
yashag2255
Dual Super User II
Dual Super User II

Hey @Clarizion 

 

Can you check and confirm if there is an apply to each in the flow? I did it like this and it works as expected: 

 

Cap1.PNG

 

cap2.PNG

 

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

5 REPLIES 5
yashag2255
Dual Super User II
Dual Super User II

Hey @Clarizion 

 

Can you check and confirm if there is an apply to each in the flow? I did it like this and it works as expected: 

 

Cap1.PNG

 

cap2.PNG

 

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

v-alzhan-msft
Community Support
Community Support

Hi @Clarizion ,

 

Please take a try to add a Compose before the "Send an email" action to save the description dynamic content as @yashag2255 's screenshot.

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Clarizion
Regular Visitor

Hey @yashag2255,

 

Thank you for your reply.   I attempted again with the modification you suggested and got nothing in the email.   I was able to update the GetItems to use an oData filter that limited it to one item (the testing item in the initial post).  So there is only one item that was being reviewed and yet there is no Description data that was collected or placed in the email.   Looking at the run data it doesn't seem like there is any description information in the XML either.  Here is what I have that still doesn't get the description field.

 

Flow Changes_001.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

The Description information disappeared when I went for a screen shot.  Flow Changes_001_popup.png

 The mail result looked like this:Flow Changes_001_mailresult.png

 

Your assistance is greatly appreciated.

v-alzhan-msft
Community Support
Community Support

Hi @Clarizion ,

 

Could you please share a screenshot of sharepoint list?

Please make sure there is a value in the the description field for items in the sharepoint list.

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Clarizion
Regular Visitor

@v-alzhan-msft,

 

Thank you for making me think about this and modify the view to have the necessary column.   I didn't think about the fact that the view itself did not have the description.   I ran the modified version on the new view and it worked.  I was obviously not thinking about the fact that this was pulling a view instead of an actual record from the backend.

 

This view works.

Flow Changes_001_EventsWithDescription.png

 

 

 

 

 

 

 

Thanks for all your help.   I am going to mark the original response as a solution.

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

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.

Top Solution Authors
Users online (1,328)