cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Dual Super User III
Dual Super User III

Re: Trying to get Calendar Event Description

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
Highlighted
Dual Super User III
Dual Super User III

Re: Trying to get Calendar Event Description

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

Highlighted
Community Support
Community Support

Re: Trying to get Calendar Event Description

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.

Highlighted
Regular Visitor

Re: Trying to get Calendar Event Description

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.

Highlighted
Community Support
Community Support

Re: Trying to get Calendar Event Description

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.

Highlighted
Regular Visitor

Re: Trying to get Calendar Event Description

@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
secondImage

August 2020 CYST Winners!

Check out the winners of the recent 'Can You Solve These?' community challenge!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

thirdimage

Power Automate Community User Group Member Badge

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

Top Solution Authors
Top Kudoed Authors
Users online (5,410)