I have a scheduled flow which is designed to check once a day for any shifts without people assigned using Shifts for Microsoft Teams. I list shifts, then I check if the open slot count > 0 if yes, I post the following message to the teams channel:
"@General There is an open shift at formatDateTime(@{items('Apply_to_each')?['sharedOpenShift/startDateTime']} , 'dd-mm') is anyone free to cover it?"
However, the message is posting into teams as the literal formula above. Why isn't it rendering the dynamic content. Even if I remove the formatDateTime(), I still get the same result.
Hi @itsmelmon
As you are passing it directly as text in the text block, it is not evaluating the expression. In the Message option for the Post a message as a flow bot to a channel, rewove the expression from the base text and then put the cursor after "shift at" and switch to the expressions and then place the entire thing there after getting rid of the '@' and curly braces.
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!
@yashag2255 Thanks for coming back to me. I have followed those instructions, please see the screenshot.
However, it is still rendering the raw text "
User | Count |
---|---|
27 | |
16 | |
15 | |
12 | |
11 |
User | Count |
---|---|
43 | |
30 | |
28 | |
24 | |
23 |