cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate II
Advocate II

Get and Send Yammer Messages via Email

Hello,

Flustered Flow User here...

I'm trying to get all messages from a Yammer group (namely the Topic and Message body), format as a table, then add the table in the body of an email and send out every Monday morning. 

I can't seem to figure out how to get a nicely formatted table - do I need to write html or can I get a table w/o code? It doesn't need to be fancy, just readable.  

Here's what I have so far, along with the email:

Yammer Flow.pngYammer Email.png

Obviously, the email is not a formatted table - what's the recipe??

 

Thanks in advance!!!

5 REPLIES 5
Highlighted
Community Support
Community Support

Re: Get and Send Yammer Messages via Email

Hi @kbarber,

 

All what you have done are correct, just remember to enable Yes for the Is HTML field in the action Send an email. You will be able to get it by clicking the Show advanced options.

I have made the following flow, please take it for a reference.

After the action Get messages in a group, add action Select.

Then the action Create HTML table. Select value from the Output of Select. Here I have customized columns. To get Value for each field, use the code likes below:

item()?['post']

 Add the action Send an email, select the Output of action Create HTML table for the Body field, and make sure enable Yes for the Is HTML field.

1.PNG

Please try again with it and feel free post back if you need more help.

 

Best regards,

Mabel

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Advocate II
Advocate II

Re: Get and Send Yammer Messages via Email

Thanks @v-yamao-msft Mabel!

So I thought I had IsHtml set as 'Yes' but when I checked, sure enough, it was not set.

However, I'm still not getting the desired result - i'm wondering if I'm not getting the formula right in the Create HTML Table step:

Yammer Flow 2.png

Here's the email output from the above Flow:

Yammer Email 2.png

Highlighted
Community Support
Community Support

Re: Get and Send Yammer Messages via Email

Hi @kbarber,

 

There is something wrong with the HTML table you created.

When creating the HTML table, we get value from the Output of the action Select. So we should get value from action Select but not Get messages in a group for each column.

Please try to configure value for Word column likes below:

Item()?[‘Word’]

I am not sure if Post in the Select action is just the same with Body you specified in Create HTML table action. If they are not the same, you may have to map a value for Body in the Select action frist.

Please let me know if you need more help.

 

Best regards,

Mabel

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Advocate II
Advocate II

Re: Get and Send Yammer Messages via Email

thanks for the reply @v-yamao-msft,

I think i fixed the Value expressions in the Create HTML Table action:

YammerFlow3.png

 

Only thing now is the email is showing the html code!

 

YammerEmail3.png

 

I have ishtml selected in the Send Email action.

 

Any way to display display as rich text?

 

Thank you thank you

-Kurt

Highlighted
Advocate II
Advocate II

Re: Get and Send Yammer Messages via Email

@v-yamao-msft - don't mean to be a nuisance, but I'm so close! any way to format the email easily? do i have to add html to the body of the email?

thank you!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

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