Email a list of Discussion Board or Discussion List posts once a day

%3CLINGO-SUB%20id%3D%22lingo-sub-389050%22%20slang%3D%22en-US%22%3EEmail%20a%20list%20of%20Discussion%20Board%20or%20Discussion%20List%20posts%20once%20a%20day%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-389050%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20have%20created%20a%20flow%20to%20email%20me%20a%20list%20of%20posts%20from%20a%20discussion%20board.%20However%2C%20I%20want%20to%20be%20able%20to%20receive%20an%20email%20with%20the%20list%20of%20items%20that%20were%20posted%20the%20previous%20day.%20I%20created%20the%20following%20flow%3A%3C%2FP%3E%3CP%3E*Recurrence%20(once%26nbsp%3B%20day)%3C%2FP%3E%3CP%3E*Get%20Items%20(from%20Discussions%20List)%3C%2FP%3E%3CP%3E*Filter%20Array%20(see%20screen%20shot)%2C%20using%20the%20expression%26nbsp%3B%40equals(item()%3F%5B'Created'%5D%2C%20addDays(utcNow()%2C%20-1%2C%20'yyyy-MM-dd'))%3C%2FP%3E%3CP%3E*Create%20an%20HTML%20table%20using%20that%20output%3C%2FP%3E%3CP%3E*Send%20Email%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tested%20this%20with%20out%20the%20Filter%20Array%20and%20it%20works%20great.%20However%20when%20I%20added%20the%20filter%20array%20I%20get%20a%20blank%20email.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20suggestions%20would%20be%20great.%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-389050%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-389402%22%20slang%3D%22en-US%22%3ERe%3A%20Email%20a%20list%20of%20Discussion%20Board%20or%20Discussion%20List%20posts%20once%20a%20day%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-389402%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869%22%20target%3D%22_blank%22%3E%40Chris%20Webb%3C%2FA%3E%26nbsp%3BI%20actually%20have%20my%20issue%20posted%20there%20as%20well.%20Not%20having%20much%20luck%20so%20I%20thought%20I%20would%20try%20this%20forum%20as%20well.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%3C%2FP%3E%3CP%3EAnnie%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-389162%22%20slang%3D%22en-US%22%3ERe%3A%20Email%20a%20list%20of%20Discussion%20Board%20or%20Discussion%20List%20posts%20once%20a%20day%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-389162%22%20slang%3D%22en-US%22%3EThere%20is%20an%20official%20Microsoft%20community%20page%20just%20for%20Flow%20here%3A%20%3CA%20href%3D%22https%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FMicrosoft-Flow-Community%2Fct-p%2FFlowCommunity%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FMicrosoft-Flow-Community%2Fct-p%2FFlowCommunity%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20will%20get%20a%20greater%20audience%20and%20more%20Flow%20pros%20able%20to%20assist%20with%20your%20question.%20For%20whatever%20reason%20this%20community%20is%20still%20on%20this%20forum.%20%3CBR%20%2F%3E%3CBR%20%2F%3EAnyway%2C%20go%20to%20that%20link%20and%20sign%20up%20and%20ask%20there%20and%20you%20should%20get%20a%20quick%20response%20hopefully%20%3B).%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hello,

I have created a flow to email me a list of posts from a discussion board. However, I want to be able to receive an email with the list of items that were posted the previous day. I created the following flow:

*Recurrence (once  day)

*Get Items (from Discussions List)

*Filter Array (see screen shot), using the expression @equals(item()?['Created'], addDays(utcNow(), -1, 'yyyy-MM-dd'))

*Create an HTML table using that output

*Send Email

 

I tested this with out the Filter Array and it works great. However when I added the filter array I get a blank email. 

 

Any suggestions would be great. 

Thank you,

2 Replies
Highlighted
There is an official Microsoft community page just for Flow here: https://powerusers.microsoft.com/t5/Microsoft-Flow-Community/ct-p/FlowCommunity

You will get a greater audience and more Flow pros able to assist with your question. For whatever reason this community is still on this forum.

Anyway, go to that link and sign up and ask there and you should get a quick response hopefully ;).
Highlighted

@Chris Webb I actually have my issue posted there as well. Not having much luck so I thought I would try this forum as well. 

 

Thank you,

Annie