I created a rule that is triggered every day at 12:00 PM PDT. This is my conditional statement.
[Future Assumptions].Filter([Dummy Values] =Today()+7).Count()
If the output of the above statement is greater than 0, then it should email something to a certain user. I want to include the output of the code below as the content of the message.
Concatenate(
"Jurisdiction : ",
[Future Assumptions].Filter([Dummy Values]=Today()+7),
LineBreak(),
'Future Model Codes : ',
[Future Assumptions].Filter([Dummy Values]=Today()+7).[Future Model Code(s)],
LineBreak(),
'Future Date Available : ',
[Future Assumptions].Filter([Dummy Values] =Today()+7).[Future Date Available],
LineBreak(),
'Future Effective Date : ',
[Future Assumptions].Filter([Dummy Values] =Today()+7).[Future Effective Date],
LineBreak(),
'Level of Confidence : ',
[Future Assumptions].Filter([Dummy Values] =Today()+7).[Level of Confidence])
However the message doesnt cater it. How can I make it possible ?