Create item in SharePoint announcement list when a Yammer Announcement is posted

[Apaelijo]

I'd like to create a SharePoint announcement list item when a Yammer Announcement is posted.

Flow can capture the Body of the Yammer announcement but the Yammer announcement Title does not show up from the list of Dynamic contents to chose from.

Thanks

[faustocapellanj · Accepted solution]

Hi @Apaelijo,

While I understand the Yammer Announcement Title is not available in the Dynamic content list, there's a way to retrieve it to achieve your goal. I decided to re-create your scenario on my end and this is how I was able to achieve it:

1. The first step is the trigger: "When there is a new message in a group". Every time a Flow runs, the trigger step returns the OUTPUTS of the respective action, which in our case is a new message in a Yammer group. Here's a screenshot of the trigger and a screenshot of the OUTPUTS from our trigger.
   TriggerTrigger Output
   
   
2. The next step is the Condition. In it you need to check if the value of the "message_type" property is announcement as shown in the second screenshot above. In the Choose a value field, click on the Expression tab and enter the expression below. And the condition to check for is equal to announcement.
   

   triggerBody()?['message_type']

   Condition ExpressionComplete Condition
3. If the condition above is true, then we proceed to create the announcement in the SharePoint announcement list. Set the Site Address and the List Name. For the Title field, use the expression below.
   

   triggerBody()['title']

   Set Title field value
4. And for the Body field, follow the screenshot below to set its value.
   Set Body field value

This approach worked for me just fine. If you try it, please let me know how it goes, and if it solved your issue, please mark your post as solved.

Regards,
Fausto Capellan, Jr

[Apaelijo]

double like!

1.) The solution is exactly what I needed - it works!

2.) Appreciate the step-by-step guide

Thanks again @faustocapellanj

[faustocapellanj]

Hi @Apaelijo

I'm glad to hear that solution for you.

Regards,

Fausto Capellan, Jr

[Anonymous]

Thanks so much for documenting this step by step.  The only part I can't match is the last step #4 where you are adding the "body" field.  I don't seem to have that option.  When I select "Create SharePoint Item", I can only complete thrugh Step #3 with the Title.  I don't see another SharePoint option for create item so how do you get the Body field to show as an option?

[faustocapellanj]

Hi @Anonymous

I did a more thorough walk-thru in a blog post about this forum post. To get the body, you should look at step #9 in the blog. Here's the link:Get Yammer Announcement Title using Microsoft Flow

Please let me know if you have any questions.

Regards,

Fausto Capellan, Jr

[Anonymous]

Thank you!  I'm still unable to get the Body field, but perhaps that is based on the custom list I created in SPO?  I am using the classic SPO (not modern).

[faustocapellanj]

Hi @Anonymous

If you haven't resolved this yet, can you please post a screenshot of your flow configuration so I can take a look?

Thanks,

Fausto Capellan, Jr

[Anonymous]

Thanks for the follow-up.  I meant to come back and post that I finally resolved the issue by re-creating the Flow from start to finish.  I never could isolate the problem in the existing Flow and wonder if something was hung up in the Cache.   Many thanks for your assistance and your step-by-step blog.